Importing from an FTP Site

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
Click to expand...
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.
 
Back
Top