Downloading a CSV file from a web site using Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 26 Aug 2004 21:17 GMT

I would like to use Access 2000 to connect with my website
and import a CSV file stored there. I tried to open the
file and connect via FTP, but I received an error
indicating that I didn't have permission to read the file.

I checked the permissions on the CSV file and it was set
to read/write for all users.

What am I doing wrong?

John

Reply to this Message

Joe Fallon - 26 Aug 2004 23:55 GMT

You cannot do this from the Access UI.

You need to use FTP in code to copy the file to a local drive and then
import it using normal techniques.
You can use code like this to implement FTP in Access:

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

Signature

Joe Fallon
Access MVP

>I would like to use Access 2000 to connect with my website
> and import a CSV file stored there. I tried to open the
[quoted text clipped - 7 lines]
>
> John

Reply to this Message