Steps to Import A Sharepoint List in MS-Access:
- The Get External Data – SharePoint Site dialogue box appears when you click Access.
- Specify the source site's address in the wizard.
- Click Next after selecting Import the source data into a new table in the current database.
- Select the lists you want to import from the list displayed by the wizard.
- Note You can link to SharePoint libraries, but you can only add content to those libraries in SharePoint.
- Select the view you want for each selected list in the Items to Import column.
- Which data is imported for lookup columns in the selected lists is controlled by the check box labelled Import display values instead of IDs for fields that look up values contained in another list.
- Click OK
Read More: Why does art drawn with MS Paint always look so bad?
