Transferring data from a physical file

Asked By Maribel Myers 0 points N/A Posted on - 02/23/2012

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.

• Status: Open
• Question Views: 1036
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by lee hung

Go To Solution

Answered By Iamexpert 0 points N/A #104571

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. 

About Iamexpert

Questions
0

Answers
195

Best Answers
34

• Vote Up 0 Vote Down

• Posted on - 02/23/2012
• Question Category: MS Excel

Best Answer

Best Answer

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.

 

About lee hung

Questions
3

Answers
1451

Best Answers
463

• Vote Up 0 Vote Down

• Posted on - 02/24/2012
• Question Category: MS Excel

Answered By Maribel Myers 0 points N/A #104573

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.

About Maribel Myers

Questions
15

Answers
6

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/05/2012
• Question Category: MS Excel