# How to Link Share point to MS Access

> To link SharePoint to MS Access, go to the External Data tab, click New Data Source, choose From Online Services, and select SharePoint List. Enter the SharePoint URL, choose the link option, click Next, and select the lists to link. The linked tables will appear in the Navigation Pane.

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

## Steps

1. Go to the 'External Data' tab on the ribbon.
2. Click 'New Data Source' .
3. Choose 'From Online Services' and select 'SharePoint List'.
4. In the dialog box, enter the URL of the SharePoint site
5. Select the 'Link Option' to link the data source by creating a linked table.
6. Click 'Next'.
7. Access will display all available lists on the SharePoint site. Select the lists you want to link. Click 'OK'.
8. The linked tables appear in the Navigation Pane, with a special icon indicating the link.