Get External Data - Excel Spreadsheet

vusi_dube

New member
Local time
Today, 23:46
Joined
Aug 19, 2013
Messages
6
Hey All,

I'm new to the forum apologies if any etiquette has not been adhered.

I'm in the process of importing an excel spread sheet from an external source (SharePoint). I have the link for the file and have edited it from the Https:// to

\\projectspace. intranet.sharpoint etc etc\.

The problem i'm having is before importing the data into a new table in my current db I get an error "The File "\\projectspace.intranet\etc etc\" does not exist. Can anyone help. Im using IE8 and the version of Access is 2007.


Any help or direction is greatly appreciated.
 
you say

\\projectspace. intranet.sharpoint etc etc\.

and

\\projectspace.intranet\etc etc

is this correct? Shouldn't they both be the same?
 
you say

\\projectspace. intranet.sharpoint etc etc\.

and

\\projectspace.intranet\etc etc

is this correct? Shouldn't they both be the same?

Sorry, meant to be the same please use as examples.
 
I was just clarifying whether this was where your problem is - regret I can't advise further as my requirements to interact with the web is quite limited and normally accomplished using API's provided by the website
 

Users who are viewing this thread

Back
Top Bottom