totn Access

MS Access 2013: Link to a table in another database

This MSAccess tutorial explains how to link to a table in another database in Access 2013 (with screenshots and step-by-step instructions).

Question: In Microsoft Access 2013, how can I link to a table in another database?

Answer: You are able to link to tables from other databases, whether the table is an Access table, an Oracle table, an Excel spreadsheet, or even a text file.

Linking to a table from another Access database

To link to a table from another Access database, select the EXTERNAL DATA tab in the toolbar at the top of the screen. Then click on the Access button in the Import & Link group.

Microsoft Access

Next, click on the Browse button and find the Access file that contains the tables that you wish to link to. In this example, we are selecting the TechOnTheNet.accdb file.

Then select the radio button called "Link to the data source by creating a linked table" and click on the OK button.

Microsoft Access

Highlight the tables that you wish to link to. In this example, we have selected the Suppliers table.

When you have finished selecting the tables, click on the OK button.

Microsoft Access

Your linked tables should now appear in your database window. You will notice the arrow to the left of the table name. That means that it is a linked table.

Microsoft Access