Microsoft Access allows us to download/import tables from databases hosted on a SharePoint site, by using a simple import wizard.
How it’s done ?
- from the External Data tab click on the More command and then on SharePoint List.
At the next step we must add a SharePoint site address, but we must also specify how the data should be imported: as a link or in a new table.
Now we must specify the username and password for the SharePoint site.
After a successful connection, the wizard will display a list with all the objects contained in the database.
Here we will select only 3 tables.
In the end, the tables are inserted as linked tables.
If we don’t need linked tables, we can easily convert them to local tables:
- right click on a table – Convert to a Local table.
Now, the linked table becomes a local table.