Retrieving data from the web

[PaulSpell]

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?

 

[PaulSpell]

Anyone?

 

[PaulSpell]

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. "

 

[bretto]

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!!!

 

[PaulSpell]

Don't want to edit just download. Could you explain how that works please?

 

[Peter D]

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,

 

[PaulSpell]

Great stuff, thanks for your help.

 

[PaulSpell]

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?

 

[SforSoftware]

Hi,

Look at the underlined paragraph at this page:
http://www.mvps.org/access/modules/mdl0037.htm

 

[PaulSpell]

Oh yeah, missed that, thanks.