|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 15th, 2009, 01:48 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Import Spreadsheet HELP
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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200904/1 
|
|
#2
April 15th, 2009, 01:59 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Import Spreadsheet HELP
hi Tore,
Tore via AccessMonster.com wrote: 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 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/...d.php?t=150077 mfG -- stefan --
|
|
#3
April 15th, 2009, 02:15 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Import Spreadsheet HELP
Stefan,
Not what I wanted to hear but thanks I will place the file back where I originally stored it. Stefan Hoffmann wrote: 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 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/...d.php?t=150077 mfG -- stefan -- -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200904/1
|
|
#4
April 16th, 2009, 03:02 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Import Spreadsheet HELP
Just a thought import/link it into Excel have Access update the data from
Excel. -- Mr C "Tore via AccessMonster.com" wrote: Stefan, Not what I wanted to hear but thanks I will place the file back where I originally stored it. Stefan Hoffmann wrote: 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 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/...d.php?t=150077 mfG -- stefan -- -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200904/1
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
