To save this request so that it can be reused, type a name for the transfer request. If desired, click on the Data Options, Format Options, and Properties buttons to change any of the options. Type the Library/Filename of the file to transfer, or Browse for the file. The default system name shown matches the Management Central system specified in System i Navigator. Specify the server name where the data is located. For the purposes of this document, a new request is created.
![where to save excel add ins where to save excel add ins](http://exceldb.net/en/wp-content/uploads/sites/2/2017/11/Excel-XLAM-add-ins-creation-300x235.jpg)
The add-in can create a new transfer request or run a transfer request that was previously saved from the iSeries Access Data Transfer from iSeries GUI interface. This opens a new Transfer Request window. Then, select the Data Transfer from iSeries icon from the toolbar as shown below or select Data Transfer from iSeries from the Data drop down menu. Step 1: Open Microsoft Excel, and display a blank worksheet. The following instructions are the same for Excel 2007 and Excel 2010 with the exception that the data transfer add-in options are found on the Excel Add-Ins tab. This document provides step-by-step instructions for using the Data Transfer from iSeries Add-In when using Excel 2003. This document assumes the add-ins are already installed in Microsoft Excel.
#WHERE TO SAVE EXCEL ADD INS WINDOWS#
Where a difference is important, the version of the product is used to identify the differences.Ĭlient Access Express and iSeries Access for Windows provide Data Transfer Add-ins for use with Microsoft Excel. For the purposes of this document, the terms Client Access, Client Access Express, and iSeries Access may be used interchangeably. These names essentially refer to the same product however, the functionality and name changed over the last several releases. Important Note: This document discusses Client Access for Microsoft Windows 95 and Windows NT, Client Access Express, and IBM iSeries Access products.