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

[Glenn Gundermann <ggundermann@xxxxxxxxxxxxxx>]

Vuong,

This is what I did in your exact position;

Change the program to also write to a physical file.  For every column of data 
on
the report, you'll need a field in the file.  You can then download this file.

Glenn Gundermann
Ronald A. Chisholm Limited
Toronto

Vuong Nguyen wrote:

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

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