If you are using Client Access then an Add-In is provided (but must be registered) to upload directly to your iSeries through Excel.
To check if it is registered in Excel check Tools->Add-Ins. This will display a window with all installed Add-Ins. Make sure that Client Access Data Transfer is checked. If it is not in the list click the Browse button and navigate to the Program FilesIBMClient AccessShared folder and select cwbtfxla.xll.
When registered two new button should appear on your toolbar to send/receive data to/from the iSeries. These transfers may also be run through the menu by selecting the Data menu option in Excel.
Hope this helps,
Last Wiki Answer Submitted: February 15, 2006 12:42 am by rarogerson0 pts.