Downloading a CSV file from a web site using Access

[John]

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

 

[Joe Fallon]

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