Ask the Expert

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.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

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 first published in March 2002

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

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: