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

["Fred Mitchell" <fred@xxxxxxxxxxxxxxxxxxxxxxxxxxx>]

To take this a bit further, what I have done in the past is as follows:

As Glenn stated, create a physical file but with only one field of, say, 200
characters.  Then as you write each detail line on the report also write to
the physical file.  I would also create this as a comma delimited file by
placing double quotes round character data and seperating all data items
with a comma.  This must all be done in the 'O' specs in the RPG program,
for example:

NumericField1
',"'
CharacterField1
'","'
CharacterField2
'",'
NumericField2

This would result in the output file looking like this:

NumericField1,"CharacterField1","CharacterField2",NumericField2

You could then use FTP to automitcally transfer this to a server or the
users PC and the data can be imported into almost any PC application.  I
have done this before as a nightly batch job so the data is waiting for the
user when they come in in the morning.

--
Fred Mitchell
Concise Consulting Ltd.
mailto:fred@concise-consult.demon.co.uk

-----Original Message-----
From: owner-midrange-l@midrange.com
[mailto:owner-midrange-l@midrange.com]On Behalf Of Glenn Gundermann
Sent: 04 December 1998 14:55
To: MIDRANGE-L@midrange.com
Subject: Re: Automating data from AS/400 to Microsoft Access.


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

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