I am trying to open (or import) a CSV file created on my remote web server using Access 2000. I try File > open then select the FTP option and the webserver which I've already configured with the username and password.

The program opens the right directory and I can see and select the CSV file -- but then I get an error indicating that the file doesn't have read permission (which it does).

How can I open this file directly in Access without having to download it first through an FTP client?

Thanks,

John