How to Create a CSV File From an AS400 File With Column Headings

Written by bonnie conrad
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Create a CSV File From an AS400 File With Column Headings
You can convert mainframe files to CSV format. (Jupiterimages/ Images)

The AS/400 file format is proprietary, meaning that you must have a specific type of software loaded to create or use it. But the comma separated value (CSV) file is more universal. You can read a CSV file into a number of different programs, including text editor programs, Microsoft Access databases and Microsoft Excel spreadsheets. Converting an existing AS/400 database file into a standard CSV format makes it available to a much larger audience of users.

Skill level:
Moderately Easy


  1. 1

    Open the AS400 file you wan to convert. Type the command "CRTPF FILE(USER999/CSVPC)" to create a blank CSV file to which you can transfer that AS400 data.

  2. 2

    Press the "F4" key. Type the record length you want to use for the file. Enter a name for the CSV file.

  3. 3

    Type the command "CPYTOIMPF FROMFILE(*LIBL/DTAFIL) TOFILE(USER 999/CSVPC)" and press the "Enter" key. Press "Enter" three more times to complete the creation of the CSV file.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.