Copy file from website

[leummens]

I'm trying to automaticaly copy a file from the internet using an Access application. This file holds data provided by one of our suppliers and will be imported into the database.

Is there a method to copy a file (TXT) to a local drive using access VBA?

rgds,
Mark

 

[patweb]

I don't know if copy exist, but to get a file from the Internet you need to use FTP or HTTP Protocols I think.

If the position (e.g

http://www.site.com/downloads/file)

of the file is known you can download him via an access HTTP or FTP module.

Search on the next site to install an add-in FTP or HTTP.

http://www.mvps.org/access/index.html

pat

 

[leummens]

Pat,

That is just what I was looking for.

Thanx for your help

Cheers,
Mark

 

[patweb]

This is the link for the InternetTransferLib.zip

http://www.mvps.org/access/modules/mdl0037.htm

pat