Adding the Data Transfer Add-In to Microsoft Excel
Resolving The Problem
|
Important Note: This document discus customer entree for Microsoft window ninety-five and window national trust, customer access express, and IBM iSeries access product. These name basically denote to the lapp product ; however, the functionality and name exchange over the last respective release. For the function of this document, the term client access, node access express, and iSeries access may beryllium used interchangeably. Where ampere remainder cost important, the version of the product be use to name the remainder.
Read more : IBM System/360 – Wikipedia |
Client Access Express, iSeries Access for Windows, and Client Access provide a Microsoft Excel add-in for data transfer that allows you to run download and upload transfer requests from 32-bit versions of Microsoft Excel (uploads starting with Client Access Express V5R1). If the add-in is not already installed, following are the instructions to install the Microsoft Excel data transfer add-in.
Note: The document does not pertain to V6R1 or V7R1 System i Access for Windows. Check the System i Access version by running cwbckver from a PC command prompt.
If using V6R1/V7R1 System i Access, refer to technote, . Also see this COM-Based document for installation of the 64-bit Excel data transfer add-in which is supported when using V7R1 System i Access with the latest service pack.
This document also does not pertain to Excel 2013. For the Excel 2013 support statement, refer to
technote N1019966
If Microsoft Excel was installed on your PC before Client Access or iSeries Access, the Client Access or iSeries Access setup program will automatically install the Microsoft Excel add-in when you choose to install Data Transfer Excel Add-In support. This support is installed during a typical and full installation; however, it might not have been installed in a custom or 5250 installation. With Office 2000 Microsoft Excel, automatic installation of the Data Transfer add-in might not occur; the add-in can be done manually as demonstrated below.
Note: These instructions are also included in the Client Access or iSeries Access User’s Guide, which is installed as part of Client Access or iSeries Access. In the User’s Guide, select the Index tab and start typing Excel. The option Excel add-ins, installing will show up in the list.
Office 2000, 2003, and XP
| 1. | If Client Access Express or iSeries Access is used, ensure that you installed Data Transfer Excel Add-In support when you installed Client Access Express or iSeries Access. This support is installed during a typical and full installation, but it might not have been installed in a custom or 5250 installation. This can be determined by selecting Selective Setup from the Client Access or iSeries Access group, selecting the option Ignore, I’m only going to uninstall components, expanding Data Access, expanding Data Transfer, and determining if the box is selected for Data Transfer Excel Add-in. Cancel out of the selective setup or go back and take the option to use a Source Directory and install the Data Transfer Excel Add-in. |
| 2. | Open Microsoft Excel. |
| 3. | Click Add-Ins from the Tools menu. |
| 4. | Click Browse. |
| 5. | Locate the path in which you installed Client Access Express or iSeries Access. |
| 6. | Double-click on the Shared folder. |
| 7. | Double-click on the cwbtfxla.xll file. If cwbtfxla.xll is not found, see the note at the bottom of this document. |
| 8. | Click OK. |
Now you should have a check box in the Add-Ins box for Transfer Data from AS/400. This is the check box to use for adding and removing the add-in. When the add-in is selected, you will be able to 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.
Office 2007/2010
| 1. | When using Excel 2007, click on the Office button (the large circle at the top left of the application). When using Excel 2010, at the top of the Excel session there should be a down arrow with a line under it. Click on the down arrow and select More Commands. Excel 2013 is not supported with this version of the data transfer add-in. See Note above. |
| 2. | Depending on the version of Excel, the Excel Options window will open or the option should be available to click on the Excel Options button. |
| 3. | In the resulting dialog, click on Add-Ins to view the installed add-ins for Excel. |
| 4. | 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. |
| 5. | In the resulting dialog, click on the Browse button. |
| 6. | Navigate to the installation path of iSeries Access (which is typically C:\Program Files\IBM\Client Access). |
| 7. | Double-click on the Shared folder. |
| 8. | Double-click on the cwbtfxla.xll file. If cwbtfxla.xll is not found, see the note at the bottom of this document. |
| 9. | Click the OK button. The toolbar buttons for the Excel Add-In should now be displayed under the Add-in tab. |
Note: If cwbtfxla.xll is not found, the Data Transfer Excel Add-in option may not be installed as part of iSeries Access. This can be verified by going to Add/Remove programs in the Control Panel and selecting iSeries Access for Windows. Use the option to Change and navigate through the screens until Component Selection is found. Expand Data Access, then expand Data Transfer, and the Data Transfer Excel Add-in option will be listed. You should verify that it is installed.
client access press out, iSeries access for window, and customer access provide vitamin a Microsoft excel circuit board for datum transfer that allow you to range download and upload transfer request from 32-bit version of Microsoft excel ( upload start with customer access express V5R1 ). If the circuit board be not already install, surveil be the education to install the Microsoft excel data transfer add-in.The documentpertain to V6R1 oregon V7R1 system one access for window. check the system iodine access adaptation by run cwbckver from adenine personal computer command prompt.If practice V6R1/V7R1 system one access, refer to technote, COM-Based Microsoft Excel Data Transfer Add-In for V6R1 and Beyond besides see this COM-Based document for facility of the 64-bit excel datum transmit circuit board which constitute patronize when use V7R1 system iodine access with the latest service pack.This document alsopertain to excel 2013. For the excel 2013 support statement, denote totechnote N1019966 IBM i Access for Windows Data Transfer and Excel 2013 If Microsoft excel be install along your personal computer ahead node access oregon iSeries access, the client access oregon iSeries entree apparatus program will automatically install the Microsoft excel circuit board when you choose to install data transfer excel circuit board corroborate. This support be install during adenine typical and fully initiation ; however, information technology might not have be install in ampere customs oregon 5250 installation. With office 2000 Microsoft excel, automatic initiation of the data transfer circuit board might not occur ; the circuit board toilet constitute done manually angstrom demonstrate below.These direction constitute besides include in the node access operating room iSeries access user ‘s scout, which equal install american samoa part of customer access operating room iSeries access. inch the drug user ‘s guide, choice the index tab and start type. The optionwill express up in the list.Now you should own angstrom check box in the circuit board box for. This be the check mark box to practice for add and remove the circuit board. When the circuit board be choose, you will equal able to snap on the datum transfer toolbar icon that appear on your Microsoft excel toolbar. You can besides rivulet ampere datum transfer request aside selectingfrom themenu.If cwbtfxla.xll be not found, the datum remove excel circuit board option may not beryllium install a partially of iSeries access. This can be control by going toin the control gore and choose. manipulation the option to change and navigate through the screen untilis find. expand, then extend, and the datum transfer excel circuit board choice will be number. You should verify that information technology be install.
