Tuesday 15 April 2014

excel - Spreadsheet stored on Sharepoint needed in Access -


I have a spreadsheet that is stored on the SharePoint site and I want to link to this spreadsheet to create a "live" I have a table in my Access database when I get a link from a data source by creating external data-> Excel-> a linked table, I get an error because the file path starts with http: Is there a workaround for this? Thanks!

You can not link to a web site, or a file sitting on some web site. You must use the Windows Media Networking System to work ()

You can download a workaround file locally in this way, and then link to the local file.


No comments:

Post a Comment