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

["Kellems, Cary" <cary.kellems@xxxxxxxxxxxxxx>]

Don,

O.K.  I'll bite.....how do you put AS/400 data into an Excel spreadsheet
using only RPGLE. 

> ----------
> From:         Don Schenck[SMTP:schencd%AM_LZCH%VASELL@mr.mops.wl.com]
> Sent:         Friday, December 04, 1998 1:24 AM
> To:   MIDRANGE-L
> Subject:      Re: Automating data from AS/400 to Microsoft Access.
> Sensitivity:  Confidential
> 
> :::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.
> 
> 
> 
> Vuong --
> 
> You may be able to link your Excel spreadsheet to your AS/400 data by
> simply
> writing an RPG program!
> 
> Say gang ... did you know that? Did you know that it is possible --
> WITHOUT
> Client Access -- to put data from your AS/400 right into an Excel
> spreadsheet
> by using an RPG/ILE program?
> 
> Peace,
> 
> -- Don Schenck
> www.SchenckTech.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
+---