Using the convert is the only why I know how.
Field header . . . . . . . . . . > *TEXT
Convert Physical File to Excel (CVTPFXLS)
Type choices, press Enter.
Label . . . . . . . . . . . . .
From file . . . . . . . . . . . > CM02045WK Name
Library . . . . . . . . . . . > OAIDTA250 Name, *LIBL, *CURLIB
From member . . . . . . . . . . *FIRST Name, *FIRST, *ALL
To stream file . . . . . . . . . > '/QDLS/CM02045.XLS'
Field delimeter . . . . . . . . *TAB Character value, *TAB...
Field header . . . . . . . . . . > *TEXT *NONE, *ALIAS, *TEXT, *FLDNAM
String delimeter . . . . . . . . '"' Character value, *NONE
Comment . . . . . . . . . . . .
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Ahmed Yusuf
Sent: Monday, October 04, 2004 12:05 AM
To: Midrange-L
Subject: File Transfer From AS/400 to Excel With Column Heading
Hi,
Does any body now how to transfer data from AS/400 to Excel with column
heading, right now when one transfers data it bring the field name with it.
And I want to get columns heading with data.
Thanks & Regards
Ahmed Hussain
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
