I am not an Access person, but the iSeries handles FTP easily. I’ve created a number of scripts to put files from Windows PCs to the iSeries.
Example of a text file I use as a script:
userid
password
lcd
lcd clientssontagpgms
cd /qsys.lib/test.lib
bin
put shlib.savf code.file
quit
Some notes:
The user and password are embedded in the script (note this is not ideal from a security perspective, but in this case it’s to my personal AS400). The cd statement changes the directory on the 400 (I am using NAMEFMT 1 as the default) to my target library. BIN indicates I want to transfer the data in a binary format.
I’m sure some Access expert can tell you how to incorporate your script in a macro/function or whatever you call it in Access.
Hope this helps.
Discuss This Question: 4  Replies