Re: Automating data from AS/400 to Microsoft Access.

In addition to Monarch (which does a nice job), EXCEL can import printed
documents directly in many cases.  It does much of what Monarch does.  Only
thing you have to do is CPYSPLF to a data base file, then get that file
onto your PC.

--Paul E Musselman
PaulMmn@ix.netcom.com




>>Weekly, a user have to print a report from AS/400
>>to get the information that she needs then manually
>>find and type it into an Excel spreadsheet
>>along with some other informations.
>
>You've run into a typical situation: the source of
>the data is in many files and there's a program
>that uses logic to combine them into a report.
>Because of that, you can't simply download the
>source data to the PC.
>
>You can add an output file to the program, then
>download that, or contact a company like Monarch who
>have a product that reads reports and converts them
>into Excel, etc.
>
>Buck Calabro
>CommSoft, Albany, NY
>mailto:mcalabro@commsoft.net



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