Download a .txt file using Access 2003

S

StuJol

i have a text file located at

http://www.easara.com/downloads/PayRollUpdates/CurrentTables/Readme.txt

and im trying to get access2003 to copy it to my local machine (C: drive)

ive tried using the following code but i get errors. Can anyone point me in
the right direction please?

SourceFile =
"http://www.easara.com/downloads/PayRollUpdates/CurrentTables/readme.txt"
' Define source file name.
DestinationFile = "C:\Program Files\Easara\Easara Home Office
Suite\PayRoll\readme.txt" ' Define target file name.

FileCopy SourceFile, DestinationFile
 
A

Albert D. Kallal

FileCopy assumes that you have windows networking for the source, and
target. (you have to be on the same windows network)..

That "URL" is certainly NOT a windows file location. To download a text file
from a web site, you can't use windows networking, you need to use some type
of "protocol" that the web site supports.

the two most common are http, and ftp.

I would give ftp a try.

how to do a ftp transfer from ms-access can be found here.

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

If you don't want to shell out, and you need additional abilities, then
there is a ftp/http library here that can download files from inside of
ms-access here:

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