I used to use the "Transfer Data to iSeries" button, but I've found it much more flexible to use Excel's built-in capability to import from an ODBC data-source.
- In Excel, click "Data", then "Import External Data", then "New Database Query"
- Select the appropriate previously created ODBC data-source, click "OK"
- Sign on to the '400 on the resulting pop-up
- Select the appropriate table, press the ">" button, and click "Next" 3 times
- Finally, click "Finish", then "OK"
The data will then be returned into Excel with all the appropriate column headings.
HTH,
DaveSlash
Main Topics
Browse All Topics
by: mvidasPosted on 2006-03-21 at 06:43:18ID: 16247109
Hi James,
I'm guessing you're talking about "cwbtfxla.xll". I used it a while ago, but found it easier (for me at least) to use other methods of getting data (running a query then using the iSeries Navigator software to move the output to my computer from the AS400 outq). I still have that add-in, so I'll try to give you some basic instructions on how to use it (though I'm by no means an expert with it).
On the Client Access toolbar that gets added, click the "Transfer Data from iSeries" button. For the Transfer Request field, choose New, and choose a starting row/cell. Click OK.
Choose the iSeries server you want to get data from, and click Next.
Choose the library/file you want to get data from, click next
The 'Data Options' button is where you define the query/what you want to retrieve. Format Options controls the format of the data, and I almost never changed the run-time options. Click next when done with that screen
If you want to save this data transfer information (if you need to do it more than once), you can do it on the next screen or just click next from there if you don't need to save it (not the information, just the transfer setup).
Click Finish
Matt