MS Access link to a Sharepoint Excel File via Connection String (1 Viewer)

[andatabase]

Hello,

I am writing to see if it is possible to connect to a Sharepoint Excel File via a connection string? It would be similar to the below:
SELECT *
FROM [Excel 12.0 Xml;HDR=YES;IMEX=2;DATABASE=Link to Excel File];

This works for files on shared drives, but I need one linking to a Sharepoint folder. I am able to connect to these files by syncing them to my OneDrive folder, but this is not convenient, as I will need for other colleagues to perform tasks from time to time.

thanks

 

[theDBguy]

Just thinking out loud, but it might be possible if your SharePoint server has WebDAV enabled. You can then map to the Document Library as a shared drive.

 

[andatabase]

Just thinking out loud, but it might be possible if your SharePoint server has WebDAV enabled. You can then map to the Document Library as a shared drive.

I will have a look. Not sure my company will allow it.