RE: File Transfer From AS/400 to Excel With Column Heading

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

The command is a free utility, information at 
<http://www.geocities.com/~alex_nubla/tips.htm>

Or you might just use 
<http://www.geocities.com/~alex_nubla/zip/cvtpfxls.zip> and get the command.

HTH
Vern

At 12:08 AM 10/5/2004, you wrote:
> Thanks Mr.Allison for replying to my message. I tried to find this command
> on our AS/400, but not able to get it. We are on Version 5 Release 1 and
> Modification 0.
>
>
> Regards
>
> Ahmed Hussain
>
>
> -----Original Message-----
> From: Dwayne Allison [mailto:Dwayne.Allison@xxxxxxxxx]
> Sent: Monday, October 04, 2004 6:29 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: File Transfer From AS/400 to Excel With Column Heading
>
> 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.
>
>
> --
> 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.
> --
> 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.