This article explains how to create a link from Access to an Excel sheet.

What is it?

A link to an excel sheet will allow access to get certain values from the excel workbook. When the values in the Excel workbook change, so will the values in the Access database.

For example consider the table below:

This table is linked to the Excel sheet below:

Assume the data in the Excel sheet is changed:

The data in the Access table will change accordingly:

How to?

Step 1: On the External Data ribbon click on the Excel button:

Step 2: Select the path of the Excel file and select the “Link to the data source by creating a linked table”:

See also:

• Linked Table Manager, Access

If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website  www.software-solutions-online.com