Need to link an Excel file that resides on SharePoint to an Access database that resides locally

[MM1963]

I’m using Access 2016.
In MicroSoft Access:
1. I go to the External Data tab.
2. I click on New data source
3. I choose from Online services
4. Then I choose SharePoint list
5. I get the pop up box for Get External Data – SharePoint Site
6. I enter the url for my company site. Example
a.

https://company.sharepoint.com/Departments/DAR

7. I click the radio button for link to the data source
8. I click next
At this point I get a pop up box that states choose the SharePoint lists you want to link to. I’m given a choice of:
• Documents
• MicroFeed
• Site Assets
• Site Pages
• UserInfo
I choose Documents and click OK, but It doesn’t give me a list of folders or even files to choose from. It creates a linked table called Documents.
Can I link to Excel Files that reside on SharePoint?
Thanks

 

[mintjulep]

I don't think so.

In SharePoint a List means something different that what you hope it does.

http://www.informit.com/articles/article.aspx?p=1622404&seqNum=6

SharePoint's API allows you to download files.

 

[spamjim]

Is there not a function with SharePoint that synchronizes local files with the SharePoint resource (like DropBox)? Consider synchronizing the Excel file as a local copy.

https://support.office.com/en-us/ar...-windows-615391c4-2bd3-4aae-a42a-858262e42a49

 

[MM1963]

Thank you both for your posts. I'm going to download file I need.