Guide

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.