How can I convert all the records from a Physical File to Exces ?

95 pts.
Tags:
AS/400 import/export
CPYTOIMPF
iSeries import/export
Physical File
V4R4
I would like to know how can I achieve this ? and I am working on V4R4. Example : PF1 contains 100 records , I need to convert this into Exces .

Answer Wiki

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

Do you mean Access, Excel, or is this some other format?
In either case, you could use CPYTOIMPF with , delimiters and open it in Excel or import it into access.
You can also link the files to Access/Excel using Client Access ODBC
And remember that Excel cannot accept more than 65000 records.
Phil

Discuss This Question:  

 
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

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