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.
