Microsoft® Access® 2010 Inside Out

Exporting Data to SharePoint

You can export data from an Access table to a Microsoft SharePoint list if you have appropriate permissions to the SharePoint site. Contact your SharePoint administrator to give you permissions if you are having trouble accessing the SharePoint site.

To export the data from an Access table, do the following:

1. Open the Access database from which you want to export the data in a table.

2. Choose the table you want to export in the Navigation pane, click the More button in the Export group on the External Data tab and then click SharePoint List. Access opens the Export – SharePoint Site dialog box. Under Specify A SharePoint Site, enter a valid address to a SharePoint Services site or subdirectory. Any SharePoint Services sites ...