Data Transfer AddIn from Microsoft Excel
https://www.ibm.com/support/pages/com-based-microsoft-excel-data-transfer-add-v6r1-and-beyond
Adding the Client Access file transfer icons to Excel (2003,2007,2010)
Open up Excel, click on tools, addins. |
|
Click Browse |
|
Browse to the c: drive, then program files, ibm, clientaccess, shared |
|
File name is cwbtfxla.xll Click ok |
|
Verify the client access data transfer is in the list; click ok. |
|
The icons should show up on the tool bar |
|
If not, click View, toolbars, and select client access. |
|
Office 2007 |
|
Click on the Excel button |
|
Then Excel options |
|
Click on Add Ins |
|
Near the bottom of the dialog, there is a pull-down box of items to manage. Ensure Excel Add-ins is selected, and click on the Go button. |
|
Click Browse.. |
|
Navigate to the installation path of iSeries Access (which is typically C:\Program Files\IBM\Client Access) |
|
Double click on the cwbtfxla and click ok |
|
The following will be displayed |
|
|
|
|
|
Excel 2013 | Click on File, options
|
Addins |
|
Click on view/manage – Change from Excel to COM |
Click Add -
|
Browse to the iSeries Access installed location – could be different on your PC. |
|
See article on internet | |
|
|
Related Articles
Adding the data transfer addin to Excel 2007/2010/2013/2016
This is an IBM document If help is needed with doing this - please call our supportdesk and we will be happy to assist you. http://www-01.ibm.com/support/docview.wss?uid=nas8N1013533 https://www.ibm.com/support/pages/node/635447Using Navigator to bring a spool file down to Excel
Using Navigator to bring a spool file down to an excel spreadsheet Open up iSeries navigator: (start, programs, iSeries, iSeries navigator) Double click on Printer Output. Be sure you can see your desktop behind the Navigator window, as ...AS400 data - mail merge with Word document
On the desktop, right mouse click, choose New, File transfer: Click Next. The system name should appear here. Click Next. This is the library name and file where the employee master information is (name, address, etc.). Click next. ...Checking version of Excel
Attached is document on finding out the Excel version running on your PC.Microsoft .NET 3.5 Install fails for Install of Spreadsheets
If the install fails of Microsoft .NET 3.5, it could be because of a group policy issue - you may need to check with technology. This would be with Windows 10 machines. Or you may need to install the .NET 3.5 Here is the link: ...