RE: PC Data Access Tools

["Brian J. Eckenrod" <beckenrod@xxxxxxxxxxxxxxx>]

If you have Client Access you should be able to use that to pull data from
AS400 files right in to an Excel spreadsheet.  Newer versions of Client
Access, aka iSeries Navigator/Access, have plugins right in to the office
suite that put buttons right on your toolbar in Excel.

A more crude, but still effective solution would be to FTP the files from
the AS400 and open them in Excel.  You would probably need to define the
column breaks in Excel when you open it, but that is not an overly
complicated task, if you know the data.

HTH,
Brian

________________________________
Brian J. Eckenrod
Paragon Consulting Services, Inc.
248 McClellan Drive
Pittsburgh, PA 15236
Ph / Fax:  412.653.2463
Mobile:     412.670.1430


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of
jwalsh@xxxxxxxxxxxxxxxxxxx
Sent: Tuesday, January 20, 2004 8:28 AM
To: midrange-l@xxxxxxxxxxxx
Subject: PC Data Access Tools


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.