Simplify AS/400--EXCEL File Transfer with CA Tools

If you run Client Access V3R1M3 or higher to access the AS/400, you can use a new Excel toolbar icon included as an add-in in Client Access to directly retrieve AS/400 file data into an Excel spreadsheet.
To enable the icon, click "Tools" and then "Add-Ins," and then check "Transfer Data" from an AS/400 checkbox. The new icon should appear just below the file drop-down menu.
When you click the icon, a simple wizard steps you through selecting the file and fields you want to transfer from the AS/400 to Excel.
This new icon is a nifty addition to Client Access because it removes a few steps from the old transfer process.
You can find the add-in under C:\Program Files\IBM\Client Access\Shared\cwbtfxla.xll.

[report a broken link by clicking here]