Import SharePoint Excel Files

[bwlytkr]

Does anyone know of a way to import excel files directly from a SharePoint into access

 

[bwlytkr]

Well it looks like I finally stumped everyone with this one. Thanks for the views and if anyone looking at this knows how to import excel files on a sharepoint directly into access I would appreciate any suggestions. Thanks

 

[JonXL]

Did you try creating a shortcut to the explorer view of your library and then accessing the file through there when importing?

It sounds like from the below that this approach would work:

https://answers.microsoft.com/en-us...ase-from/52b49ab2-c1e6-4cae-b000-11bddba89c8d

 

[bwlytkr]

I'm not sure how to create a SharePoint library in access as the link suggested. any idea on how to do that? If I do this will this link to the actual sharepoint site update as changes are made on the actual sharepoint site?

 

[Micron]

Your question is not clear for a black & white guy (me). You don't import files into Access unless you want to experience huge bloat in your db file size. So, supposing what you actually want is the data:
from my limited experience of meshing SharePoint (Excel) and Access on a network drive, it's been my observation that a sp server has an address like any other network server IF the sp server is part of the network architecture. If it's an IP address then this won't work - find out what the full path of the sp server is on the network and use it as the path to import from. The other question related to a networked sp server is, is linking not an option?