skip to Main Content

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.

How to download a table from an online Access database ?

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.

How to download a table from an online Access database ?

Now we must specify the username and password for the SharePoint site.

How to download a table from an online Access database ?

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.

How to download a table from an online Access database ?

In the end, the tables are inserted as linked tables.

How to download a table from an online Access database ?

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.

How to download a table from an online Access database ?

Now, the linked table becomes a local table.

How to download a table from an online Access database ?

(Visited 3 times, 1 visits today)

Cosmin Tătaru

Pasionat de blogging și tehnologie încă din 2009, Cosmin este aici să vă ajute să vă creșteți vânzările și productivitatea punând tehnologia la treabă pentru dumneavoastră.

Suport-Clienti
Mergeți sus