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

If you users have a 5250 emulation package, try using an ODBC Driver.






vuongtn2@hotmail.com on 12/04/98 08:58:20 AM

Please respond to MIDRANGE-L@midrange.com

To:   MIDRANGE-L@midrange.com
cc:    (bcc: Jim Anderson/KKI/US/ICENET)
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
+---