How to Link Share point to MS Access

‍

‍

Linking a SharePoint list to Microsoft Access allows you to interact with SharePoint data directly from Access. Here’s how to do it:

‍

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.