Can you offer steps or a document with instructions for how to access AS/400 data using Excel ODBC drivers, and...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
download data to Excel?
I used the old Client Access ODBC data drivers to create a data source following IBM's documentation and tested it successfully from Excel.
I also wrote a tip for Search400.com on using Java JDBC to directly access AS/400 data using the free IBM JDBC driver in the Java toolkit (JT400.jar) that is available on every AS/400. How to use Java to integrate Excel worksheets.
Finally, you can use built-in commands to move data from an AS/400 file as ascii text csv file to Windows via an IFS shared folder from your pc. The commands are:
- CPYTOIMPF (copy table or file data to a flat ascii csv delimited file in an IFS folder)
- Use Windows Explorer to map a network drive to an IFS folder and copy the CSV file or use it in Excel.
If you were interested in a good, powerful solution, you should look at Groovy. It beats all the industry options for integrating anything I've seen. You can directly access Excel content from a simple Groovy script as well as reading AS/400 data via the JDBC driver.
Dig Deeper on iSeries Java programming
Related Q&A from Jim Mason
Java to Excel with the AS400 may be attractive, but if you have complex VBA macros in Excel, the JDBCODBC bridge will not work well for you. A better...continue reading
Learn why database pooling on iSeries causes jobs on server to remain active.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.