<br>I have a client with no in-house programmers (or even an operator) for <BR>
the AS/400. However, they frequently have a requirement to get their AS/400 <BR>
spool files into Excel, so they can massage the data. Because they don't have <BR>
programmers on staff, they are interested in a tool that can do this function <BR>
for them. I know there are tools around, but haven't used any of them. <p>
Any comments or suggestions any of you have are welcome, and I'll pass them <BR>
along. <p> Thanks, Debbie Gallagher

<br>I use a product by Evergreen Interactive that works great. There are <BR>
more elaborate tools on the market, but this one is reasonably priced.<p>
They have an evaluation copy on their web site.<p> <A ><BR>
HREF="http://www.evergreeninteractive.com"> Here </A> is a link.<p> Mark <BR>
McCall<br> <hr> <i>On Thursday, May 06, 1999, 08:46 AM, Debbie Gallagher <BR>
wrote:<br> <br> I have a client with no in-house programmers (or even an <BR>
operator) for the AS/400. However, they frequently have a requirement to get <BR>
their AS/400 spool files into Excel, so they can massage the data. Because they <BR>
don't have programmers on staff, they are interested in a tool that can do this <BR>
function for them. I know there are tools around, but haven't used any of <BR>
them. <p> Any comments or suggestions any of you have are welcome, and <BR>
I'll pass them along. <p> Thanks, Debbie Gallagher <br> </i>

<br>The May/June issue of AS/400 Network Expert (ANE) just published a tech <BR>
tip on several ways to do this manually by using Client Access for Windows <BR>
95/NT V3R1M3 and above or the new Express client. If you don't get ANE, you can <BR>
&nbsp;contact Midrange Computing for a sample issue. <p> <p> Joe Hertvik<br>
Editor-AS/400 Network Expert<br> hertvik@midrangecomputing.com<br> <a ><BR>
target=_new href="http://www.midrangecomputing.com/ane"><a target=_new ><BR>
href="http://www.midrangecomputing.com/ane"><a href="http://www.midrangecomputing.com/an">http://www.midrangecomputing.com/an</a> <BR>
e</a></a>

<br><i>On Thursday, May 06, 1999, 08:46 AM, Debbie Gallagher <BR>
wrote:<br><br> I have a client with no in-house programmers (or even an <BR>
operator) for the AS/400. However, they frequently have a requirement to get <BR>
their AS/400 spool files into Excel, so they can massage the data. Because they <BR>
don't have programmers on staff, they are interested in a tool that can do this <BR>
function for them. I know there are tools around, but haven't used any of <BR>
them. <p> Any comments or suggestions any of you have are welcome, and I'll <BR>
pass them along. <p> Thanks, Debbie Gallagher <br> </i><p><p><p>
<HR> we link the file with M$_ACCESS then you can read it in Excel but not <BR>
update the original 400 file.......<p><p><pre> <H4>Bob Hamilton TEXAS
BUSINESS SYSTEMS 736 Pinehurst Richardson, Texas 75080 <h4> </pre></h4></h4>

<br><i>On Thursday, May 06, 1999, 08:46 AM, Debbie Gallagher wrote:<br>
<br> I have a client with no in-house programmers (or even an operator) for <BR>
the AS/400. However, they frequently have a requirement to get their AS/400 <BR>
spool files into Excel, so they can massage the data. Because they don't have <BR>
programmers on staff, they are interested in a tool that can do this function <BR>
for them. I know there are tools around, but haven't used any of them.
<p> Any comments or suggestions any of you have are welcome, and I'll pass <BR>
them along. <p> Thanks, Debbie Gallagher <br> </i> <p> My <BR>
shareware utility called Spooled File Tools (SPLTOOL) will do this. There is <BR>
an option to strip out the headings as well, so they won't have to worry about <BR>
that if the headings are standard across pages. <p> Just save the spooled <BR>
file to a .txt file with the headings stripped out, open the text file in <BR>
excel, and let it autoformat making the columns. I have done this many times <BR>
with great results. <p> Getting the spooled file to the PC can be done in one <BR>
of many ways too. You can use shared folders, the IFS, or even FTP (if you <BR>
have an FTP server running on your PC.) <p> SPLTOOL does a lot more, too. <BR>
Check it out at: <a target=_new ><BR>
href="http://prairie.lakes.com/~bvstone/as400sw.html"><a target=_new ><BR>
href="http://prairie.lakes.com/~bvstone/as400sw.html"><a href="http://prairie.lakes.com/">http://prairie.lakes.com/</a> <BR>
~bvstone/as400sw.html</a></a> <p> Click on download and then follow the <BR>
SPLTOOL link. <p> <P><A HREF="http://prairie.lakes.com/~bvstone/"><IMG ><BR>
SRC="http://prairie.lakes.com/~bvstone/images/sig.gif"></A></P>

Take a look at our WinSpool/400 and DataImport software for downloading and <BR>
&nbsp;converting AS/400 reports to MS Excel, Access, RTF, PDF, etc... <p>For more information, please contact me via Email or visit our web site. <p>Regards, <BR>
Richard Schoen <BR>
RJS Software Systems <p>Phn: 612-822-0412 <BR>
Fax: 612-822-1364 <BR>
Email: This e-mail address is being protected from spam bots, you need JavaScript enabled to view it <BR>
Web Site: <a href="http://www.rjssoft.com">http://www.rjssoft.com</a>

I am not able to get to your web page re: Spltool. Has it moved ?