Sharepoint Excel Access Connection

[horatiu00]

Hello,

Do you know how can i link a excel file from sharepoint to access database? I know that the connection is possible with a list from sharepoint, but it is possible to link also with a excel file from a sharepoint? Thank you in advace!!

 

[Micron]

Did you open the Linked Table Manager in Access and try to navigate to the folder where the file is kept? On ribbon,
External Data > New Data Source > From File > ...

 

[horatiu00]

Yes @Micron but i can link just the excel files from my PC not from the sharepoint...

 

[Micron]

I guess you'll have to do a bit of searching. Try "ms access link to sharepoint excel file". Here's a couple I looked at:

https://answers.microsoft.com/en-us/msoffice/forum/all/linking-and-excel-file-stored-on-sharepoint-to-ms/64c0d03d-e606-4b02-a00e-b641ad260b07

I realize the vid is for connecting Excel to SP workbook file but once you've discovered the SP path it would be basically the same on Access ribbon.

 

[horatiu00]

I saw a lot of solutions but for PowerBi or Excel not Access The above video is also for powerbi and excel... tks anyway

 

[Micron]

I think you're missing the point - it shows how to get the SP path and then use it wherever you want to link it to. At least that's my understanding. I have pushed Access data from Access to SP workbooks using Automation and can tell you that you need to know that server path to even get started. I guess that's about all I can offer. Hope you figure it out.

 

[horatiu00]

Yes man. Thank you. I know how to get the path of a SP file but how i'm connecting the path with access? This was my question. Where is the option on access "get data from web"? Thank you anyway for replying.

 

[Micron]

There are 12 or so options on where to get external data from. Did you not find them from suggestion in post 2?

 

[horatiu00]

Yes. As i said in the first post i need the connection with a SP excel file not a SP list.

 

[JonXL]

I'd think to do it just like a regular Excel file but use the SP path instead of browsing to a path on your PC,

Import or link to data in an Excel workbook - Microsoft Support

You can import Excel data into Access desktop databases or link to an Excel file, which results in a linked table.

support.microsoft.com