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

Have you tried using ODBC in ACCESS to pull the data down from the 400.  You
could even generate an output file with (or instead of) the report and then
use a Linked table in ACCESS to export it to your Excel spreadsheet.

Joe Giusto II
Patuxent Publishing Company
 <mailto:jgiusto@patuxent.com> mailto:JGiusto@patuxent.com
http://www.lifegoeson.com <http://lifegoeson.com> 


        -----Original Message-----
        From:   Vuong Nguyen [SMTP:vuongtn2@hotmail.com]
        Sent:   Friday, December 04, 1998 8:58 AM
        To:     MIDRANGE-L@midrange.com
        Subject:        Automating data from AS/400 to Microsoft Access.

        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.  I want to incorporate the datas
she 
        needs automatically by linking or exporting from AS/400 to Microsoft

        Access.

        At first, I try to create a physical file out of the report's spool
file 
        then export to excel, then extract it in Access.  But there are so
many 
        data problems arises.

        So, I decided to trace the report's source files and do some linking

        from there, I used the command DSPPGMREF to do it.  It gaves me a
report 
        listing several program files and input files.  I look some of the
input 
        files, some are report headers, some informations.  I don't know how
to 
        piece together these files.

        Any suggestions or advise.

        Please help!!!!!!!!!!!!!!! Vuong.

        ______________________________________________________
        Get Your Private, Free Email at http://www.hotmail.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
        +---
+---
| 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
+---