# How to Link Tables in MS Access

> To link tables in MS Access, open your database, navigate to the External Data tab, select New Data Source, and choose From Database and Access. Browse to locate the source database, select the Link option, click OK, choose the desired table from the dialog box, and click OK.

Canonical: https://livedemo.ai/tutorials/how-to-link-tables-in-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a4838ab56e05a00ff2fe7/preview?step=1

## Steps

1. Open the Access database where you want to link the tables. Go to the 'External Data' tab in the ribbon.
2. Click 'New Data Source', select 'From Database' and click on the 'Access' button.
3. If you choose 'Access', click 'Browse' to locate the source Access database.
4. When prompted, choose the 'Link' option. This ensures the data remains in the original location, and you interact with it in your current database.
5. Click 'OK'.
6. A dialog box will appear listing available tables or sheets. Select the table you want to link. Click 'OK' to confirm.
7. The linked tables will appear in the 'Navigation Pane' with a small arrow icon, indicating they are linked.
