Q

Accessing AS/400 data using Excel ODBC drivers

There are a couple of options for accessing AS/400 data, from the old way using Client Access ODBC drivers, to Java, to a new application from Groovy.

Can you offer steps or a document with instructions for how to access AS/400 data using Excel ODBC drivers, and 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:

  1. CPYTOIMPF (copy table or file data to a flat ascii csv delimited file in an IFS folder)
  2. 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.

This was first published in May 2008

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close