RE: getting spool file to MS Excel

There are also a number of products (Monarch for Windows is the one I'm
familiar with, but by no means the only one) that will reformat your spooled
file into a spreadsheet, automatically creating the column headings,
stripping of the page headings and footers, correctly formatting numbers and
characters etc. etc.

Re-keying printed output is ridiculous. In Cagatay's situation I would
expect the payback period on Monarch or a similar product to be extremely
short.

Dave Kahn 
Johnson & Johnson International (Ethicon) France 
Phone : +33 1 55 00 3180 
Email :  dkahn1@jnjfr.jnj.com (work) 
           dkahn@cix.co.uk      (home) 

-----Message d'origine-----
De: Barbara Turner [mailto:bturner@lionel.com]
Date: 28 July 1999 22:16
À: RPG400-L@midrange.com
Objet: Re: getting spool file to MS Excel


If you add a CPYSPLF after creation of the spool files to copy the spool
files to a file.  You can then use client access to bring the file down to
the PC.  Or you could use FTP.  If the spool file is a single line per
record this works very nicely.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *