how to read attributes from multiple shapefiles

[AaronObermiller]

Hello,

I hate to wade into a technical forum with such a basic question, but I am out of messing around time on this project.

Background: a Municipal client has Arc data for their water lines and sewer mains.  I need to determine the linear feet of the sewer mains for their operating permit.  It has been 13+ years since I had any in-depth analysis education in Arc and don't remember how to perform this operation.  I only have ArcGIS Explorer (though I can go use their computer presumably with a "complete" version).  This is a tiny town, no one knows how to use their system (believe it was set up for them under contract ages ago).

Question: Is it possible to have ArcGIS Explorer list out all lengths of a shapefile (SEWERMAIN) in tabular form that I could just enter into a calculator, or export to excel?  It would be very difficult to try and select each line individually and retrieve it's length.

Additional Info:  I have a working knowledge of ACad and other technical programs and should be able to follow technical advise well.

[AaronObermiller]

To answer my own question after messing around with the program this morning, QUERY was the function I was looking for.  That being said, if anyone has input on how I could export the values in the query dialogue box into a spreadsheet program it would be immensely helpful.  If that is only available on a higher-end version, please let me know that as well.  If it is worth my while I would buy a seat of the basic program.

[MarkBockenhauer]

Click the query layer in the table of contents.
Click Table window button (tools tab on the ribbon.)

From the table window you can save as a textfile.
the text file will be delimited with |  

You can search and replace with a text editor and save as .csv

Mark