How to export an AS/400 physical file to Microsoft Excel?

5 pts.
Tags:
AS/400 import/export
Microsoft Excel
Physical File
how to export as400 physical file to excel

Answer Wiki

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

Hi,

Easiest way is to use CPYTOIMPF to create .CSV file and import the .CSV file to Excel.

Regards,

Martin Gilbert.

Discuss This Question: 2  Replies

 
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
  • dinuas400
    Yes you can use CPYTOIMPF and in the AS400 emulator we can use the TTo(FIle transfer from iseries)
    510 pointsBadges:
    report
  • Brijesh
    Hi,

    You can convert by using STRPCCMD, If you want it to run as part of the CLP you can
    create a file transfer, using the properties tag to 
    Close when finished, Run automatically, omit display transfer completion mesasge
    the transfer request extracts the as400 file and puts it on to the c drive. then launch excel to read the file

    /* strta PC organiser */
    STRPCO
    /* download to user pc using previous request */
    STRPCCMD PCCMD('Progra~1\IBM\Client~1\cwbtf.exe C:\tfr.TFR') PAUSE(*NO)  
    /* Launch excel with downloaded file */
    STRPCCMD PCCMD('C:\Progra~1\Micros~2\Office\excel.exe C:\file.XLS') 
     or 
    f you have installed the total Client Access application, you can directly retrieve AS/400 files from your as/400 to excel with the excel "transfer data from AS/400 option"

    This option you can find in excel by menu option "data" (you also see here the "to AS/400 transfer")
    If it is not in the datamenu, you can look if the add-in is available by selecting in excel:
    => Tools => Add-ins => (select Client Access Data transfer and click OK)

    If you choose now "data" and the transfer option, you can not only download the data, but also select the required fields and records by some SQL windows

    Hope this helps.
    8,305 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