Download a .txt file using Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top