Q

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

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.

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