How to Link Share point to MS Access
- George Apostolov
How to Link Share point to MS Access: step-by-step guide
Go to the 'External Data' tab on the ribbon.
Click 'New Data Source'.
Choose 'From Online Services' and select 'SharePoint List'.
In the dialog box, enter the URL of the SharePoint site
Select the 'Link Option' to link the data source by creating a linked table.
Click 'Next'.
Access will display all available lists on the SharePoint site. Select the lists you want to link. Click 'OK'.
The linked tables appear in the Navigation Pane, with a special icon indicating the link.
Quick answer: 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.
About this tutorial
Connect SharePoint lists to the app by entering the site URL and selecting tables to establish a linked data source. This guide shows how to link Share point to MS Access in 8 steps, starting with "Go to the 'External Data' tab on the ribbon" and finishing with "The linked tables appear in the Navigation Pane, with a special icon indicating the link". The interactive demo above is a click-through copy of the real product interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to link Share point to MS Access?
8 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your data or settings. Once you know the flow, repeat it in your own workspace.
Create your first interactive demo in minutes
No credit card required • Start building today
