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"
Dig Deeper on i5-OS
Related Q&A from Kent Milligan
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor ... Continue Reading
When working with DB2 files with columns that have both short and long names, there is no option choose which column names are returned via ODBC ... Continue Reading
When developing tables in a parent-child relationship, use a primary key and a foreign key along with a unique ID to make your database easier to ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.