Transfering Spreadsheet Data to AS/400

[Guest.Visitor]

I am working with a client that wants to take data sent to them in a spreadsheet and load it to the AS/400. What are the options out there to do that? Mike Wilson

[Guest.Visitor]

VBA-ADO is the best I've used yet. Search the MC site and you will find articles explaining how to do this. They show select statements but any SQL is possible. (INSERTS, CALLS, etc..) Tx

[Guest.Visitor]

Send the CSV file to the AS/400 and then use command CPYFRMIMPF.

[daly.michael@verizon.net]

Most terminal emulation products (at least all the ones i've ever used) come bundled with a transfer utility that will handle this for you. Michael