You are presented with an error when you do not have an active Excel spreadsheet. Before you select the output device of Active Excel Spreadsheet, make sure you opened Excel and have an active spreadsheet. 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.