RE: Easiest and most functional way to convert selected spoolfilesinto Excel

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Yeah, that works for a data file - Dave was asking about spooled 
files. You'd need to use CPYSPLF or one of the spooled file APIs 
first to get things into a PF. CPYSPLF will put out a single column 
file - well, maybe it can use an externally-defined PF as the target 
- interesting possibility - to get fields. Anyway, it's more 
complicated, usually, when dealing with spooled files.

Regards
Vern

At 07:40 AM 4/25/2006, you wrote:

> Did anyone mention CPYTOIMPF  (check spelling)...  this command will
> copy a flat file to a CSV format file and put it in the IFS folder of
> your choice.  CSV is readable by Excell.  CPYTOIMPF is free; comes
> with OS/400.
>
> --Paul E Musselman
> PaulMmn@xxxxxxxxxxxxxxxxxxxx
> --
> 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.