FTP Table from Access 2003 DB to Mainframe File

[Guest]

I have looked through the previous posts using FTP from Access but wasn't
sure how I'd code my problem. I need to FTP a Table in the form of a TXT
file to a preallocated dataset on an IBM mainframe server.

I have read the several different ways to do this but am a bit confused. I
would really like to accomplish the FTP without adding a 3rd party add-in. I
can manually extract the table to a TXT file, then manually FTP it to the
mainframe but would like to put the process in VBA code so that the user can
do it with the click of a button.

Thanks for your help

Nancy Welch
Application Developer
King County ITS

 

[Douglas J. Steele]

For a simple, no-frills approach, see
http://www.mvps.org/access/modules/mdl0015.htm at "The Access Web". For a
more sophisticated approach, see
http://www.mvps.org/access/modules/mdl0037.htm