Materi Microsoft Access : Manage linked tables

How to manage linked tables :

1. On the External Data tab, in the Import & Link group, click Linked Table Manager.
2. In the Linked Table Manager dialog box, select the check box for the table or tables whose link you want to update, and then click OK. If the source file is not in the original location, Access displays the Select New Location dialog box.
3. In the Select New Location dialog box, find the new location for the file, select the file, and then click Open.
4. In the Linked Table Manager message box, click OK.

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.