Use the Excel Add-in that's included with the iSeries Client Access for Windows software.
You get a cool little icon on your Excel tool bar for uploads and downloads.
But I agree the ODBC connection option's offer you much more features.
If Microsoft Excel was installed on your PC after Client Access Express, do the following:
1 Ensure that you installed Data Transfer Excel Add-in support when you installed Client
Access Express. This support is installed during a typical and full installation but may
not have been installed in a custom or 5250 installation.
2 Open Microsoft Excel.
3 Click Add-Ins from the Tools menu.
4 Click the Browse button.
5 Locate the path where Client Access Express was installed.
6 Double-click on the shared folder.
7 Double-click on the cwbtfxla file.
8 Click OK.
Now you can click on the data transfer toolbar icon that appears on your Microsoft
Excel toolbar. You can also run a data transfer request by selecting Transfer
Data From AS/400 from the Data menu.
Last Wiki Answer Submitted: April 26, 2011 6:01 pm by Teandy5,830 pts.