Downloading Files Using Client Access In CSV Formats

25 pts.
Tags:
AS/400 Client Access
Client Access
Client Access 5.8
Client Access 5.x
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
ASKED: November 12, 2009  9:41 PM
UPDATED: November 13, 2009  10:47 PM

Answer Wiki

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

So you’re doing a file transfer from the iSeries to your desktop via Client Access into Excel? Sorry just need to clarify.

Discuss This Question: 3  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
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • Craig Hatmaker
    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
    1,610 pointsBadges:
    report
  • AndreaF
    If you are transferring into an excel file, you should be able to simply "Save As" a CSV format from there.
    7,570 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