Your department or workgroup uses Access, but you are occasionally pointed to a SharePoint list for additional data that must be merged into one of your databases.Ĭomplete these steps before you import the list You can import the list into Access, and then delete the list from the SharePoint site. To permanently move data, such as a contacts list, to an Access database, because you no longer need the information on your SharePoint site. Here are common reasons for importing a SharePoint list into an Access database: An import specification helps you to repeat the import operation in the future without having to step through the Import Wizard each time. At the end of the import operation, you can choose to save the details of the import operation as a specification. During the import operation, you can specify the lists that you want to copy, and, for each selected list, you can specify whether you want to import the entire list or only a specific view. When you import data, Access creates a table and copies the columns and items from the source list (or view) into that table as fields and records. Publish a database by using Access Services
What do you want to do?Īdvantages of linking data between Access and SharePoint For more information on deploying Access, see Deploy an Access application. This recommendation applies to all types of Access files including a single database, a split database, and the. If more than one person opens the Access database from SharePoint, multiple copies of the database may get created and some unexpected behaviors may occur. The file may be downloaded locally for editing and then uploaded again once you save your changes to SharePoint. Warning Although you can save an Access database file to OneDrive or a SharePoint document library, we recommend that you avoid opening an Access database from these locations. Moving creates lists on the SharePoint site that remain linked to tables in your database and maintains their relationships. Linking connects to data in another program, so that you can view and edit the latest data both in SharePoint and Access. Importing creates a copy of the SharePoint list in an Access database. Want to combine and enhance both Access and SharePoint? To do so, you can import, link, or move data between them. Access for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013 SharePoint in Microsoft 365 Access 2010 Access 2007 More.