I would also be interested in a
program that would convert to .xls on the 400. I am doing it with remote
command. That means I have to leave a PC on all the time (and hope it is
running OK).
If the kenetech product was
priced as good as the excellent Gumbo Software products, I'd buy it in a
minute.
Art Tostaine,
Jr. CCA, Inc. Jackson, NJ 08527
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 +---
|