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

[Chuck Lewis <CLEWIS@xxxxxxxxxx>]

That's REALLY too bad because back in the days when we chose Surpass I felt 
that Monarch was the superior (in fact I KNOW it WAS because I think it's 
Window's version was out for a year or so before Surpass came out with one 
!!!)...

jeffreycarey@usa.net wrote:

> 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
> +---



+---
| 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
+---