Extract info from the i5 into an Excel database file

Data Transfer Base Support and Data Transfer Excel Add-In (Under Data Access - Data Transfer)

Once installed, activate the iSeries Access Data Transfer feature add-in:

1. Open Excel worksheet

2. Select Add-Ins from the Tools pull-down menu.

3. Select the iSeries Access Data Transfer feature

To set up an SQL statement that returns data to the worksheet:

1. From the pull-down menu "Data", select "Transfer Data from iSeries"

2. From Transfer Request dialog window, select "Create New"

3. Specify the iSeries system name

4. On next dialog window, specify the library/file name

5. On next dialog window, press the "Properties" button

6. Select the "SQL" tab

7. Select the option "Process Select as native SQL" and Press OK

8. Press the "Data Options" button

9. From the "Change SQL Select Options" dialog window, enter your SQL statement and press OK

10. Press Next

11. If you want to save this definition so you can run it again later, specify a file name with the .DTF extension

12. Press Finish

The results of your query should be returned to the active worksheet.

Excel also has some data transfer features that allow you access iSeries data using ODBC drivers to access the system. If you want to play around with those, here's how to get started:

1. From the pull-down menu "Data", select "Import External Data" -> "New Database Query"