CODEWITHSUNDEEP
excelms-accesssharepoint
Brian Hill
Brian Hill

Reputation: 23

Spreadsheet stored on Sharepoint needed in Access

I have a spreadsheet that is stored on a SharePoint site and I would like to link to this spreadsheet to create a "live" table in my Access database. When I go to Get external data->Excel->Link to the Data source by creating a linked table, I get an error because the filepath begins with http:. Is there a workaround for this? Thanks!

Upvotes: 0

Views: 62

Answers (1)

Albert D. Kallal
Albert D. Kallal

Reputation: 49309

You cannot link to a web site, or a file sitting on some web site. You need (must) use the windows file networking system for this to work.

You thus could as a workaround download the file local, and then link to the local file.

Upvotes: 1

Related Questions