![ibm i access client solutions data transfer ibm i access client solutions data transfer](https://www.ibm.com/support/pages/system/files/inline-images/image-20190402093150-4.png)
If you have multiple instances of Excel open or multiple spreadsheets open in the instance of Excel being used, select the spreadsheet you want to populate with the downloaded data. You are presented with an error when you do not have an active Excel spreadsheet.
![ibm i access client solutions data transfer ibm i access client solutions data transfer](https://www.mcpressonline.com/articles/images/1999/AS-_400_Integrated_File_System_Solutions__Part_3..06-00.jpg)
Before you select the output device of Active Excel Spreadsheet, make sure you opened Excel and have an active spreadsheet.
IBM I ACCESS CLIENT SOLUTIONS DATA TRANSFER PC
In the lower section, you can select the output device on the PC and the name of a PC file when the File output device is selected.įor the purposes of this document, we are going to download a file to an active Excel spreadsheet. In this example, we are using the file QCUSTCDT in library QIWS a small example file shipped with IBM i. In the Data Transfer window, the top section includes input for the IBM i system name or IP address and the IBM i library and file name. You can add more data transfer requests to the session by using the Actions menu option or the up or down arrows.įor this document, we are using the tab labeled 'From IBM i - 2'. You can use the tabs shown just beneath the menu and toolbar to select upload or download. You are presented with the following window:Ĭlick 'Data Transfer' in the left menu options and you are presented with the following data transfer session panel: Following are the steps to download a IBM i file into an active spreadsheet by using IBM i Access Client Solutions data transfer from IBM i.įirst, open the Access Client Solutions interface.