MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2004

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



fixed

I have a zip of several useful SQL based data conversion tools, written by
Giuseppe Costagliola.  I downloaded it from one of the newsletter sites
(can't remember which), but I'll be happy to forward the original zip
collection that I downloaded.  It contains the following commands:

SQL2CSV
SQL2XLS
SQL2XML


Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Vern Hamberg [mailto:vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx]
Sent: Wednesday, October 06, 2004 6:59 AM
To: Midrange Systems Technical Discussion
Subject: RE: File Transfer From AS/400 to Excel With Column Heading


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.


--
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