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

andatabase

New member
Local time
Today, 07:42
Joined
Jul 23, 2015
Messages
14
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

I’m here to help
Staff member
Local time
Yesterday, 23:42
Joined
Oct 29, 2018
Messages
21,542
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

New member
Local time
Today, 07:42
Joined
Jul 23, 2015
Messages
14
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.
 

Users who are viewing this thread

Top Bottom