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

["Draper, Dale" <dale.draper@xxxxxxxxxxxx>]

Create a QUERY report that creates a file, then "file transfer" it to an
Excel sheet. (or Access, or a .txt file.....) 

Dale Draper
Sega Enterprises
650-802-3272
dale.draper@seu.sega.com


> -----Original Message-----
> From: Vuong Nguyen [SMTP:vuongtn2@hotmail.com]
> Sent: Friday, December 04, 1998 5: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
+---