Manage Learn to apply best practices and optimize your operations.

Extract data from the iSeries 400

Can I extract data from the iSeries 400 to a NT 4.0 or XP server (Excel, Access?)

The best way to get external data from iSeries 400 is by using ODBC driver. The Client Access ODBC driver is considered to be a very good option.

After you define the ODBC data source the iSeries data base is like any other SQL data base and you can connect to it from:

* Office (Word, Excel)
* Access
* Asp page
* ODBC compliant clients such as business object brio etc.


Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.

The Best Web Links: tips, tutorials and more.

This was last published in March 2002

Dig Deeper on Remote Access to iSeries

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.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.