Import Spreadsheet HELP

  • Thread starter Tore via AccessMonster.com
  • Start date
T

Tore via AccessMonster.com

I am trying to import spreadsheet from an internet site, the code below
worked great for a server location but when I modified it for the web site
address I get a invalid internet site message can someone tell me where I am
incorrect in my sysntax. see below
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTest", "http:
//test-test-test/sites/test/TestCoordination/Test Forecast/forcast.xls
 
S

Stefan Hoffmann

hi Tore,
I am trying to import spreadsheet from an internet site, the code below
worked great for a server location but when I modified it for the web site
address I get a invalid internet site message can someone tell me where I am
incorrect in my sysntax. see below
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTest", "http:
//test-test-test/sites/test/TestCoordination/Test Forecast/forcast.xls
Click to expand...
You cannot access a file this way. you have to download it first, store
it on a local (LAN) drive. E.g.

http://www.access-programmers.co.uk/forums/showthread.php?t=150077


mfG
--> stefan <--
 
T

Tore via AccessMonster.com

Stefan,
Not what I wanted to hear but thanks I will place the file back where I
originally stored it.
 
Top