RE: Easiest and most functional way to convert selectedspoolfilesintoExcel

I agreee, go get it from the data is the best. And even if it's "just a 
one-time request", there will be more.

However, I have found a few times, depending on how convuluted the program 
logic is that produces/produced the spool file, and depending on its expected 
maintenance future, it is occasionally easier/better/more cost effective to 
extract the data yourself. Or maybe use one of the 3rd party products mentioned 
earlier in the thread. 

--Alan



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of
daparnin@xxxxxxxxxxxxxx
Sent: Tuesday, April 25, 2006 11:15 AM




Yea, forget the spool file.  Go straight to the source--the files.  A
product like Showcase (www.spss.com) makes it easy to create queries with a
GUI or with SQL that can be linked to Excel spreadsheets.  Once created
they prompt to be refreshed each time you open the spreadsheet.  Showcase
includes a report writer and security options that go above regular OS/400
security.

You could also do a direct access via ODBC.  You could do a download into
Excel format through the Client/Access download option.


Dave Parnin
--
Nishikawa Standard Company
Topeka, IN  46571
daparnin@xxxxxxxxxxxxxx