Get External Data - Excel Spreadsheet

[vusi_dube]

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.

 

[CJ_London]

you say

\\projectspace. intranet.sharpoint etc etc\.

and

\\projectspace.intranet\etc etc

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

 

[vusi_dube]

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.

 

[CJ_London]

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