Re: Download a .txt file using Access 2003
- From: "Albert D. Kallal" <PleaseNOOOsPAMmkallal@xxxxxxx>
- Date: Sun, 9 Sep 2007 10:14:23 -0600
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
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@xxxxxxx
.
- Prev by Date: Re: Best way to import text file into existing table on a daily ba
- Next by Date: Re: Best way to import text file into existing table on a daily ba
- Previous by thread: dde in access 2007
- Next by thread: Re: Export function from Outlook to Access Data base
- Index(es):
Relevant Pages
|
