Downloading Files Using Client Access In CSV Formats
I am downloading a data file using Client Access. I would like to create the file in the CSV format is there a to include the column headings in the data file?
Software/Hardware used:
iSeries 520 - Clint Access Version 5.8
Software/Hardware used:
iSeries 520 - Clint Access Version 5.8
ASKED:
November 12, 2009 9:41 PM
UPDATED:
November 13, 2009 10:47 PM
RELATED QUESTIONS
- SAP - Create CSV from Text format
- Ability to perform AS/400 file transfers in batch
- Data report from iSeries to a CSV format need page breaks and colors
- How can I transfer a file from th as/400 to my documents as a csv file using client access?
- Sending email with attachment in CSV format using SNDDST
Answer Wiki:
So you're doing a file transfer from the iSeries to your desktop via Client Access into Excel? Sorry just need to clarify.
To see all answers submitted to the Answer Wiki: View Answer History.
Minor note… there is no “Client Access Version 5.8″. I suspect that you mean iSeries Access V5R4 which includes Personal Communications Workstation Program Version 5.8. The iSeries Access version/release is not the same as the version/release of the emulator program. In nearly every case, questions will be about the iSeries Access version/release.
With iSeries Access V5R4, there is a new transfer type. See Client Access Data Transfer – Description of File Types and look at the last transfer type — Microsoft Excel XML Spreadsheet . Not exactly .CSV, but it’s compatible with Excel and can carry column headings.
Tom
If your goal is to put iSeries data into Excel (with column headings) this tutorial shows an laternative method to do just that with what you already have (nothing to buy) and without having to create any RPG or CLP objects, or run any CL commands. Everything is contained in native MS Excel. All VBA code is provided. Once you have copied the code to your spreadsheet, creating new reports with drill down pivot tables and charts takes no more time than creating a Query.
http://itknowledgeexchange.techtarget.com/beyond-excel
If you are transferring into an excel file, you should be able to simply “Save As” a CSV format from there.