as400 to excel
how to move the control from as400 to excel and copy the data from excel again move to as400
Software/Hardware used:
Software/Hardware used:
ASKED:
January 13, 2010 10:46 AM
UPDATED:
January 15, 2010 4:47 PM
Answer Wiki:
In Client Access you can set up the data transfer from and to an iSeries server. You can manage your addins from there.
Here is a really quick but step by step method to get data from your 400, iSeries or system i into Excel:
<a href="http://www.as400tutorials.com/as400-to-excel/">AS400 to Excel</a>
Long story short there are many ways to skin this cat
To see all answers submitted to the Answer Wiki: View Answer History.
Sounds like you want to initiate an upload from Excel to DB2 on the i. To do this, look into Excel VBA programming, and ADO.
If you are using the Client Access add-ins for Excel, it is possible to send data from an Excel spreadsheet to the AS/400 and let the system automatically create a file to receive the data. The field names are very generic but it works. This is the simplest way to handle such transfers. If the job needs to run in a production environment, you will probably want a more controlled transfer of data.
Here is a really quick but step by step method to get data from your 400, iSeries or system i into Excel:
AS400 to Excel
-JA