Re: [Re: Getting an AS/400 Printout into Excel...]

I know someone in a previous post mentioned Monarch.  We tried to use that and 
had nothing but trouble.  I think Monarch was bought since the days when they 
used to frequently advertise in AS/400 publications.  The tech staff we dealt 
with knew nothing of the AS/400 - kind of a problem, since the documentation 
didn't tell you how to get the report from the host to the PC - only what to do 
once it was there! 

We ended up having to abandon Monarch - it simply couldn't handle the complex 
report we were trying to get it to read (the report had a lot of breaks, etc. - 
not nice neat columns!)



uucp@Uucp1.mcs.net wrote:
> Thanks Pete !
> 
> I'm working on the per Rob's post and per my reply to him, having a problem
> (duh...)
> 
> Chuck
> 
> Pete Hall wrote:
> 
> > At 12:59 PM 6/29/98 -0400, Chuck Lewis wrote:
> > >Any one know of a quick and easy way to get an AS/400 printout into an
> > >Excel spreadsheet ?
> >
> > Use CPYSPLF to put the spooled output into a physical file (CTLCHAR(*NONE)),
> FTP that to an ASCII file with a .TXT extension and just open it with Excel,
> which will prompt you for import information (column positions, data types,
> starting column, starting row). Once you've got it into the spreadsheet, sort
> the data to make the headers all gravitate to one spot in the spreadsheet so
> that they can be deleted with one swell foop.
> >
> > hth
> > Pete
> >
> > Pete Hall
> > peteh@inwave.com
> > http://www.inwave.com/~peteh/
> >
> > +---
> > | 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
> +---


____________________________________________________________________
Get free e-mail and a permanent address at http://www.netaddress.com/?N=1
+---
| 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
+---