Import SharePoint Excel Files

bwlytkr

Board Regular
Joined
Jun 8, 2012
Messages
70
Does anyone know of a way to import excel files directly from a SharePoint into access
 

bwlytkr

Board Regular
Joined
Jun 8, 2012
Messages
70
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
 

bwlytkr

Board Regular
Joined
Jun 8, 2012
Messages
70
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

Well-known Member
Joined
Jun 3, 2015
Messages
1,742
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?
 

Forum statistics

Threads
1,077,731
Messages
5,335,893
Members
399,056
Latest member
CityGirlLuv

Some videos you may like

This Week's Hot Topics

Top