Importing iSeries data directly into an Excel spreadsheet

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT DB2/400 and DB2 UDB When is the YES option for 'reuse deleted files' function the best choice? Monitoring members 'stuck' within a physical file on an EDI system Developing tables in a parent-child relationship in DB2 SQL server error message -321 Creating a host variable of the 'where in' statement in SQL Choose which column names are returned via ODBC when working with DB2 files Allow access to data from a stored procedure result set using COBOL or RPG Access path and an open data path differences Convert a numeric physical file to a character in SQL without leading zeros Inserting data from a CTE into a file in SQL

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

First make sure that the following components of iSeries Access are installed: Data Transfer Base Support and Data Transfer Excel Add-In (Under Data Access - Data Transfer)

If they are not, you may not have a license for the data transfer capability. The use of Data Transfer in iSeries Access for Windows and Client Access Express requires an iSeries Access Family (5722-XW1) license. For more information refer to the Order/Upgrade tab on the iSeries Access Web site.

I would also recommend that you upgrade to the V5R3 or V5R4 client version of iSeries Access. Don't worry -- you will still be able to access System i5 servers at V5R2.