RE: Suggestions for importing Spool Files

AFAIK There is no pretty solution to this without 3rd party software. And
IMO even those are not as pretty as some might like. 
Have you considered having the reports generating this spoolfile, generate a
file instead? Files are very simple to import (even into preformatted .xls
files) using ODBC and an Excel template file.


> -----Original Message-----
> From: Jim Cannon [SMTP:JimC@Arizonabiltmore.com]
> Sent: Thursday, March 29, 2001 8:15 AM
> To:   'MIDRANGE-L@midrange.com'
> Subject:      Suggestions for importing Spool Files
> 
> I am looking for solutions for the following situation. 
> 
> I want to import spooled reports to Excell.
> 
> We do not have and RPG compiler, nor do we have access to the source
> members. 
> 
> I know there are Vendors that provide such utilities, but have never had a
> need for one before.
> 
> CPYSPLF is just too cumbersome for a user.
> 
> Any suggestions would be greatly appreciated.
> 
> Thanks 
> 
> 
> Jim Cannon
> Systems Specialist
> Arizona Biltmore Resort and Spa
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---