Have multiple csv files posted to a remote server and made available for download (on a password protected web page). Need to import these csv files into an existing dbase. The dbase is set up on local machine and works perfectly importing the files from a local directory. Now need to replicate this via FTP (or some other method) to import the remote csv files in to the local dbase.
FTP not working with Access 2002 - cannot access csv file on remote server despite correct ftp settings and correct permissions on server itself. Is there VB code available that can automatically log on to an FTP site and retrieve the required csv file(s)? Using the import facility, Access 2002 gives and error of "Internet Login Failure" - this is despite already allowing the user to explore the relevant directories on the web server (i.e. Access has already been viewing remote server files so how can it then say internet login failure!?).
Maybe there is a problem with the local set up of MS office but I have followed the MS instructions for setting up the ftp facility for the proxy server (this help was from the MS knowledge base).