I'm trying to automate the importation of some txt file into Access. However, the files are located at an FTP site which has a user name and password. The TransferSpreadsheet method has no arguments regarding an FTP site. Please help.
Access can't do it natively.
You have to write code to shell out to the FTP process.
Then you can connect to the ftp server and log in and get the file and bring
it down to your local PC and then use TransferText on it.
See this site for sample code: http://www.mvps.org/access/modules/mdl0015.htm
--
Joe Fallon
Access MVP
BigManT said:
I'm trying to automate the importation of some txt file into Access.
However, the files are located at an FTP site which has a user name and
password. The TransferSpreadsheet method has no arguments regarding an FTP
site. Please help.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
