RE: Generating PC file formats from AS/400 data

[Joel Fritz <JFritz@xxxxxxxxxxxxxxxx>]

If you're using Client Access, and they have remote capability, there are a
couple of options.  The addin that can be installed on the Data menu of
Excel will import a 400 file directly into a spreadsheet.  I think you can
probably set it up with a file transfer definition.  Client Access file
transfer also supports downloading to .xls .wk4, or .dif format.    

If you're e-mailing the files, you might consider building an assortment of
predigested files.  I've had some experience supporting non-technical remote
users, and feel your pain.  Even though the majority are nice well meaning
people, they can consume huge amounts of your time.  Someone braver than I
might try to force standard software on them.


> -----Original Message-----
> From: Mark Allen [mailto:markallen@kellyskids.com]
> Sent: Tuesday, August 08, 2000 9:14 AM
> To: MIDRANGE-L
> Subject: Generating PC file formats from AS/400 data
> 
> 
> We have recently stated sending data to our sales reps in the 
> field as CSV
> files.  It is running completely on the AS/400, no problems with that.
> However, there are a number of our reps who have little to no 
> PC expertise
> and they are having major issues (which in turn is causing us 
> more work)
> importing/opening the data in their "program of choice".
> 
+---
| 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
+---