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

Try Compleo.....www.symtrax.com

Don in DC

On Wed, 16 Dec 1998, Joe Giusto wrote:

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

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