The first thing you need to do is to make sure Client Access is added to Excel. Follow these steps:
1. In Microsoft Excel, select "ADD-INS" under the "TOOLS" Menu.
2. If "Client Access data transfer" is displayed check the box, otherwise do step three.
3. Click "Browse" and browse through the folders:PROGRAM FILES
CWBTFXLA should be there
Now just select the button from your tool bar to transfer data from the iSeries.
================================== MORE INFORMATION ON THIS TOPIC ==================================
The Best Web Links: tips, tutorials and more.
Visit the ITKnowledge Exchange and get answers to your developing questions fast.
Ask the Experts yourself: Our application development gurus are waiting to answer your programming questions.
This was first published in August 2005