View Full Version : Transfering Spreadsheet Data to AS/400
01-01-1995, 02:00 AM
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
02-16-2001, 05:55 AM
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
02-18-2001, 04:35 PM
Send the CSV file to the AS/400 and then use command CPYFRMIMPF.
02-19-2001, 04:43 PM
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
Powered by vBulletin® Version 4.1.5 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.