I am wondering if there is a certain method in which you can transfer data from a physical file that saves you the trouble of changing the file in Excel. The reason for this is because my attempt of doing it using the Excel Data Transfer Add In yielded cells that had a syntax which was impossible to read, it seems as if a space is being populated with a 4040 string. I am also interested in how to have the columns populated correctly in the cells. Thanks in advance for your help.
Transferring data from a physical file
Hi
This is the problem with your excel skills right so you need to populate your cells right so there is the easy way through which you can populate your cell which is:
1. In excel there is a bar at the top in which whatever you are writing in the cell will appear in that bar and if you populate your cell just write the values over there. You can add any sort of formula to that bar and it will working the whole column cell.
2. At the top right corner of your excel there is option of cell formatting through which you can make changes and make your cell populated and then it will work according to your choice.
Answered By
lee hung
75 points
N/A
#104572
Transferring data from a physical file
To transfer the data from a physical file to an excel sheet, you need to follow the step by step instructions described below:
1. After opening the MS Excel program, click the tools option located in the toolbar.
2. You will see iSeries Access Data Transfer button. Click on it. If it is not displayed then click on the double arrow.
3. A new window will open (Transfer Data Window)
4. In this new window, select “Create New” and then decide if you want column headings.
5. Press the “OK” button (Click on it)
6. Now you need to choose the iSeries server from where the data will be downloaded. Select the appropriate server, and then click the “Next” button.
7. You need to select the member from which the data to be transferred to Excel Spreadsheet.
a. If the name of the library/file (member) is known,
i. Type the name directly
ii. Click the “Next” button.
b. If not known, you need to browse for it.
i. Click the “Browse” button. Now, a new window may be displayed. It will connect to the iSeries. Type the user ID and Password.
ii. A library list will be displayed. Click the (+) symbol located besides the library containing the file.
iii. List will expand and will display all the files under that particular library. If there are members in the file, it will show the list of the members.
iv. Locate the member from which the data to be transferred and double click on it.
v. Click on the “OK” button.
vi. Click the “Next” button.
8. Click “Next” button in the next screen that appears.
9. If you require using this transfer request again, you better save the file. To do this, type a suitable file name and the location to store the file. Otherwise do not write anything in the File Name box, keep it blank.
10. Click on the “Finish” button and you are done!
You will see the Excel sheet populated with the file records.
Limitation Warning: The maximum number of records that can be transferred from a iSeries physical file to an Excel sheet is 65,535.
Transferring data from a physical file
Thanks Heiley Paint for your iSeries Access Data Transfer Solution. I followed what you said and it worked. Thank you so much for helping me. I'm beginning to lose hope with this thinking that I have to manually transfer data which will take a lot of time. Thank you again. Thanks TechyV for making my life easier.