How do I export Access to SharePoint?

Question

To export your Access web app tables to SharePoint lists, complete the following steps. Open your Access web app in your web browser, and then click Settings > Export to SharePoint Lists. You'll see a confirmation message asking if you're sure you want to export the tables.

How do I export an Access database to SharePoint?

Follow these steps:1From your database, right-click on the table on the left pane and select Export.2Select SharePoint list from the drop-down menu.3In the Export data to SharePoint list window, enter the URL of your SharePoint site and specify the name for the new list.4Click OK.

How do I move Access to SharePoint?

Access opens the Get External Data – SharePoint Site dialog box. In the wizard, specify the address of the source site. Select the Import the source data into a new table in the current database option, and click Next. From the list that the wizard displays, select the lists that you want to import.

How do I link Microsoft Access to SharePoint?

1On the External Data tab, select More > SharePoint List.2Specify the SharePoint site.3Select Link to the data source by creating a linked table, and then click Next.4Select the list you want to link to, and then click OK.

How do I export an entire Access database?

To export data from Access, first select the table or other database object to export in the Navigation Pane. Then click the “External Data” tab in the Ribbon. Then click the button in the “Export” button group for the file format to which to export the object.

Expert · Answer