• Subject: Re: [Re: Getting an AS/400 Printout into Excel...]
  • From: PaulMmn <PaulMmn@xxxxxxxxxxxxx>
  • Date: Wed, 1 Jul 1998 22:23:40 -0400
  • In-Reply-To: <19980630191127.10599.qmail@www05.netaddress.usa.net>

>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:'

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

| 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 thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].