Does anyone know how to link Excel files in Sharepoint Document Library to Microsoft Access? For example, I would like to import the "Food Menu.xlsx" under "Documents" into Microsoft Access. How can I do that? I know list in Sharepoint can be imported to MS Access directly, but I don't know how to do that with Sharepoint Document Library.

Any help would be much appreciated.

CodePudding user response：

You may try the followings to check the outcome:

1.On your computer, install the latest version of OneDrive sync client from this article.( in the part of Install and set up )

2.Use OneDrive sync client to sync Excel files which are stored in SharePoint libraries to your computer.You can refer to this article Sync SharePoint files with the new OneDrive sync clientPlease also refer to this article to enable users to sync SharePoint files with OneDrive sync client for Windows.

3.After the Excel files are synced to your computer, open Access application, try the steps below:click External Data tab>New Data Source>From File>Excel>click Browse for File name>then locate the OneDrive sync folder in File Explorer on your computer, select an Excel file, click Open>OK>click Next for several times until the Finish button shows, click it.