RE: Generating PC file formats from AS/400 data

I need to do this about 1000 times (i.e. 1000 spreadsheets each sent to a
different user) and email from the AS/400 (these are remote sales reps  in
all 50 states + PR and Guam

Mark Allen
IS Manager
Kelly's Kids
markallen@kellyskids.com

-----Original Message-----
From: owner-midrange-l@midrange.com
[mailto:owner-midrange-l@midrange.com]On Behalf Of Draper, Dale
Sent: Wednesday, August 09, 2000 7:45 AM
To: 'MIDRANGE-L@midrange.com'
Subject: RE: Generating PC file formats from AS/400 data


Using Excel and an ODBC driver, create an Excel query, you can then import a
file, sort and total it (optional) and save the resulting file as an Excel
template.  Thereafter, each time the template is opened, it refreshes
(downloads) the latest data from the as400 file selected in the query and
driver.


> -----Original Message-----
> From: Robin Riker [SMTP:rikerr@riker-riker.com]
> Sent: Tuesday, August 08, 2000 11:33 AM
> To:   MIDRANGE-L@midrange.com
> Subject:      Re: Generating PC file formats from AS/400 data
>
> I am also very interested in this topic.  It seems like we've covered this
> ground before but I couldn't find it in the
> archives.
>
> What I would like to do is run a job stream on the AS/400 that creates the
> files (I already have this), then
> automatically download those files into EXCEL format. I have been using
> the Client Access Data Transfer function but
> would like to avoid the manual effort involved.  Perhaps the function
> exists in Ops Navigator?  I am going to see if I
> can create a batch file to download all of the files from a desktop icon
> next, that would be closer than what I have
> now.  I looked at CPYTOPCD but it didn't seem to provide for inputting
> straight into EXCEL format.  My users are also
> challenged by the download/import process.
>
> Any help would be greatly appreciated,
>
> TIA
>
> Robin Riker
>
>
>
> +---
> | 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
+---