Mark,
I am having the same problem, so I have been doing some
research. Gumbo software has a program called Spool-A-Matic that will
transform spool files into .TXT, PDF, and RTF files right on the AS/400.
If you are using J.D.Edward there are utilities in the FastR report tool that
will create PC Files. Another option is ShowCase Strategy software, this
software makes it easy to pull info down and configure it into any of the
formats you mentioned.
>>> markallen@kellyskids.com 08/08/00 12:13PM >>>
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".
What I am looking for is a way (on the AS/400) to generate the
file as an
Excel spreadsheet (.XLS), Lotus (.123) or a MS Works worksheet
and database
(.WKS, .WDB) so they can avoid the import function, having to
resize columns
to fit existing data, etc. Want them to be able to
just double click on the
attachment and voila, data is there and formatted
in their program of
choice.
Any ideas????
Mark Allen
IS
Manager
Kelly's Kids
markallen@kellyskids.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
+---
midrange.com
