Convert as400 file to Excel and Pdf

10 pts.
Tags:
AS/400 to PDF
DB2/400
Exporting AS/400 to Excel
PDF
Physical File
I would like to transfer a PF data into Excel , my add ins not working. Can u provide me any other ways to do that.

Software/Hardware used:
AS400

Answer Wiki

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

Use the CPYFRMIMPF command to create a CSV file on the IFS. The open it with excel. You can also look into using the Apache POI APIs to create the sheet in excel directly from your program.

Check the archives for examples of how to do both of these.
**********

You can also use ODBC to download directly from your AS400 to a spreadsheet… here is a step by step tutorial for <a href=”http://www.as400tutorials.com/as400-to-excel/”>downloading as400 to excel</a>

If you have Client Access installed on your system then you should have the ODBC driver to do this.

There are also lots of third party software packages that allow you to query into spreadsheets.

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
  • Yorkshireman
    You say ' my Add ins not working' If you have the tools already there, why not fix whatever is stopping it from working?
    5,580 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