Re: PC Data Access Tools

We use Showcase.  It does a lot of what you can do in AS/400 queries and a
lot that you can't.  It enforces AS/400 security and has the option for
some of it's own to restrict library, file, field, and record access.
Showcase queries can be used to populate Excel spreadsheets.  Overall, it's
a pretty easy and flexible way to get data into spreadsheets.

Dave Parnin
Nishikawa Standard Company
Topeka, IN  46571
daparnin@xxxxxxxxxxxxxxxxxx



                                                                                
                              
                      jwalsh@haverfordp                                         
                              
                      olice.org                To:       
midrange-l@xxxxxxxxxxxx@SMTP@CTB                     
                                               cc:                              
                              
                      01/20/2004 08:27         Subject:  PC Data Access Tools   
                              
                      AM                                                        
                              
                      Please respond to                                         
                              
                      Midrange Systems                                          
                              
                      Technical                                                 
                              
                      Discussion                                                
                              
                      <midrange-l@midra                                         
                              
                      nge.com>                                                  
                              
                                                                                
                              
                                                                                
                              



I am looking for a tool to extract data from different files on the 400
and display the data results in a spreadsheat like tool which has the
capability to do further analysis (sort, summarize, count, average, etc.)

Please forward recommendations.  Thanks.

John Walsh

Sgt. John P. Walsh
Haverford Township Police Department
1010 Darby Road
Havertown, PA 19083
Voice     610.853.1298 x 212
Cell         484.571.5497
jwalsh@xxxxxxxxxxxxxxxxxxx
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.