Materi Microsoft Access : Link to an Excel worksheet or named range

 How to link to an Excel worksheet or named range :

1. On the External Data tab, click Excel in the Import & Link group.
2. In the Get External Data dialog box, click Link to the data source by creating a linked table, click Browse to locate the source file, and then click OK.
3. In the Link Spreadsheet wizard, select the worksheet or named range that has the data you want to link to, and then click Next.
4. Specify whether the first column of the data includes column headings, and then click Next.
5. Enter a name for the linked table.
6. Click Finish, and then click OK in the Link Spread sheet wizard message box that confirms the table was linked.