If you want to recreate the lookup to another table, see Link to a SharePoint list and Move data to SharePoint. Access doesn't import the looked up table. If a source column looks up values in another list, Access imports the display values as part of the field itself. Items inside a folder also appear as records, immediately below the record corresponding to that folder. Then use the ImportSharePointList Macro Action to specifyВ the intended View ID.Д®ach folder in the SharePoint list becomes a record in the Access table. To avoid this problem, create a view of the list in SharePoint and add to it only the columns that you want, ensuring that the total number of columns doesn't exceed 256. The following table explains some considerations to keep in mind when importing different elements:ДЄccess imports only the first 256 columns, since it supports only 256 fields in a table. Review the columns in the source list or view. If necessary, create a view that contains just the columns and items that interest you. You can import multiple lists in a single import operation, but you can import only one view of each list. Identify the lists that you want to copy to the database, and then decide whether you want the entire list or just a particular view. Locate the SharePoint site that contains the lists that you want to copy, and make a note of the site address.ДЄ valid site address starts with or followed by the name of the server, and ends with the path to the specific site on the server. 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.

Access export to tap forms