FTP

[Cory J. Laidlaw, Beyond01.com]

Hi,

I need to FTP files automatcially. Does anyone have any ideas on how to do
this from VBA?

Thank you!

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/modules/mdl0015.htm and/or
http://www.mvps.org/access/modules/mdl0037.htm at "The Access Web"

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


"Cory J. Laidlaw, Beyond01.com"

 

[Cory J. Laidlaw, Beyond01.com]

Hey Doug,

Looks like great stuff! Thanks for the tip!

Cory

 

[Ron2006]

We have used the following with 2003 and XP

Finalsource = "ftp://ftpaddress.com/abc/TDD/CND_APP_Detail/ " &
"Spreadsheetname.xls"

DoCmd.TransferSpreadsheet acImport, 8, "TDI_Target2", Finalsource,
True, "TDI_Target2!"

Ron