MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2004

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



fixed

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.







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact