P PaulSpell Registered User. Local time Today, 00:21 Joined Apr 19, 2002 Messages 201 Aug 20, 2003 #1 Can anyone tell me how to connect to a text file database on the web, from a local Access database and copy records into a table?
Can anyone tell me how to connect to a text file database on the web, from a local Access database and copy records into a table?
P PaulSpell Registered User. Local time Today, 00:21 Joined Apr 19, 2002 Messages 201 Aug 20, 2003 #2 Anyone?
P PaulSpell Registered User. Local time Today, 00:21 Joined Apr 19, 2002 Messages 201 Aug 20, 2003 #3 Nevermind, I just found this on the MSDN Access Developer Centre: "Microsoft Access 2000 does not support importing or linking data from a remote FTP or HTTP server. "
Nevermind, I just found this on the MSDN Access Developer Centre: "Microsoft Access 2000 does not support importing or linking data from a remote FTP or HTTP server. "
B bretto Registered User. Local time Today, 00:21 Joined Jun 25, 2003 Messages 29 Aug 20, 2003 #4 True you cant manipulate data on a web server directly with access but you could get an ftp object library and use this to download the text file and then connect to it locally. Not great i know but just an idea!!!
True you cant manipulate data on a web server directly with access but you could get an ftp object library and use this to download the text file and then connect to it locally. Not great i know but just an idea!!!
P PaulSpell Registered User. Local time Today, 00:21 Joined Apr 19, 2002 Messages 201 Aug 20, 2003 #5 Don't want to edit just download. Could you explain how that works please?
P Peter D Registered User. Local time Today, 00:21 Joined Sep 7, 2000 Messages 188 Aug 20, 2003 #6 The example file downloaded from the site below should help you get the file from the Internet site to your local computer: Internet Data Transfer Library http://www.mvps.org/access/resources/downloads.htm Hope this helps,
The example file downloaded from the site below should help you get the file from the Internet site to your local computer: Internet Data Transfer Library http://www.mvps.org/access/resources/downloads.htm Hope this helps,
P PaulSpell Registered User. Local time Today, 00:21 Joined Apr 19, 2002 Messages 201 Aug 20, 2003 #7 Great stuff, thanks for your help.
P PaulSpell Registered User. Local time Today, 00:21 Joined Apr 19, 2002 Messages 201 Aug 21, 2003 #8 Followed the link but could only find one tool for A97, I need it for Access 2000. Do you know of anywhere else I might this info?
Followed the link but could only find one tool for A97, I need it for Access 2000. Do you know of anywhere else I might this info?
S SforSoftware (NL) SnelStart specialist Local time Today, 01:21 Joined Aug 16, 2003 Messages 239 Aug 21, 2003 #9 Hi, Look at the underlined paragraph at this page: http://www.mvps.org/access/modules/mdl0037.htm
P PaulSpell Registered User. Local time Today, 00:21 Joined Apr 19, 2002 Messages 201 Aug 21, 2003 #10 Oh yeah, missed that, thanks.
