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

[PaulMmn <PaulMmn@xxxxxxxxxxxxx>]

>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've used Monarch over the years... but haven't used it a lot recently.

In the Early Days Monarch had its own download program.  It worked fairly
well.  Of course, that was the Old, OLD version of PC support.

The way to get the reports to the PC these days is to CPYSPLF to a 133 byte
record length Physical File.  Then use CPYTOPCD to copy the file to a
shared folder on the AS/400.

Then, 'simply' access the file in the shared folder from your PC as an 'I:'
drive.

Then Monarch can access the file and do its thing.

Of course, these days a modern spread sheet program has a lot of options
for importing documents. We've had some success just reading the file from
the I: drive directly into a spreadsheet (or data access) program and
fixing it there.  Makes Monarch almost unnecessary.

--Paul E Musselman
PaulMmn@ix.netcom.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
+---