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.

Back To Top