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

Ahmed,

Search the archives for the following utilities ZFFD, ZFFDTOCSV and ZCPYTOCSV. 

Good Luck

Regards,

Emmanuel Zannis

-----Original Message-----
From: Ahmed Yusuf [mailto:ayusuf@xxxxxxxxxxxxxxxxxx]
Sent: 5 October 2004 6:08 AM
To: Midrange Systems Technical Discussion
Subject: RE: File Transfer From AS/400 to Excel With Column Heading


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.
The above information is confidential to the addressee and may be privileged.  
Unauthorised access and use is prohibited. If you received this message in 
error please tell us by reply (or telephone the sender) and delete all copies
from your system.

Internet communications are not secure and therefore this Company does not 
accept legal responsibility for the contents of this message. This e-mail 
message has been swept by Activis e:)scan for the presence of detectable 
computer viruses, but we cannot guarantee that it is virus-free and you should 
scan this email for viruses prior to opening or saving any attachments.

If you are not the intended recipient, any disclosure, copying, distribution or 
any action taken or omitted to be taken in reliance on it, is prohibited and 
may be unlawful.

Please note that communications sent by or to any person through our computer 
systems may be viewed by other members of the Hogg Robinson group.

Hogg Robinson plc
Registered Office: Abbey House, 282 Farnborough Road, Farnborough, Hampshire 
GU14 7NJ
Registered in England and Wales No 2107443