How do I import data from SharePoint to Access?

How do I import a SharePoint list into Access?

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.Video: Link to shared data - Microsoft Support

How do I export a SharePoint list to Access?

Export the data1On the External Data tab, in the Export group, click the More button to drop down a list of options and then click SharePoint List.2The Export - SharePoint Site export wizard opens.3In the Specify a SharePoint site box, enter the address of the destination site.Export a table or query to a SharePoint site - Microsoft Support

Can you import data into Microsoft Access?

You can import tables, queries, forms, reports, macros, or modules from one Access database into your current database. When you import an object, Access creates a copy of the object in the current database.

Does Access work with SharePoint?

Access 2010 and Access Services provide a platform for you to create databases that you can use on a SharePoint site. You design and publish a web database by using Access 2010 and Access Services, and people who have accounts on the SharePoint site use the web database in a web browser.