How can I copy records from a Physical file to Excel Sheet ?

95 pts.
Tags:
CPYFRMIMPF
CPYFRMSTMF
CPYTOIMPF
CPYTOSTMF
I would like to know about copying records from a physical File to Excel sheet , Can any one brief me in this regards ? Eg: I have a PF called ATMLIB/ATMTRA. EXC.XLS is a Excel Book . Now this is the situation . I am working on V4R4M0. I would like to know on this version whether it can be possible or not ? Same in reverse also from Excel to PF .
ASKED: July 8, 2009  8:02 AM
UPDATED: July 8, 2009  3:54 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi Chrisjam,

You can copy records from Iseries to excel by using Iseries utility(Data transfer from Iseries).

this option is available in Tool bar.

by using (Data transfer from Iseries) utilty u can do vice versa

or

you can configure your excel application with iseries to trasfer data to or from iseries into excel by following bellow steps:

1. Go to Add or remove bottons option in excel
2. Click on customize option.
3. Click on Toolbars option.
4. Go to end and tick iseries access option and close

now you can directly copy records from excel to iseries or copy records from iseries to excel by clicking two buttons on top of excel sheet.

i hope this information helps you

Regards,
Mohan K

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • graybeard52
    A nice tool is CVTPFXLS which can be downloaded from http://www.geocities.com/SiliconValley/Pines/5581/tips.htm
    3,115 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following