Download spool files to Excel

[Guest.Visitor]

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

[Guest.Visitor]

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

[Guest.Visitor]

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

[Guest.Visitor]

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

[Guest.Visitor]

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

[Guest.Visitor]

Take a look at our WinSpool/400 and DataImport software for downloading and converting AS/400 reports to MS Excel, Access, RTF, PDF, etc... For more information, please contact me via Email or visit our web site. Regards, Richard Schoen RJS Software Systems Phn: 612-822-0412 Fax: 612-822-1364 Email: richard@rjssoft.com Web Site: http://www.rjssoft.com

[Guest.Visitor]

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