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