I read your article on importing iSeries data directly into an Excel spreadsheet with great interest, as I have been performing this function manually for quite some time and was unaware the there is an add-in for Excel. Unfortunately, when I select Tools/Add-ins as you suggest, the "iSeries Access Data Transfer" feature is not in my list of available add-ins. I'm using Excel Professional 2003 and iSeries Access for Windows V5R2M0. Is there a trick to making this option available?
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.
Dig Deeper on DB2 UDB (universal databases)
Related Q&A from Kent Milligan
Create a host variable of the where in statement on the fly with dynamic SQL. Continue Reading
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