4

I am trying to get a list of street names and ranges for a specific area of my map. My intention is to make a street index of sorts from this data. I would like to export this data into excel if possible. Does anyone know if this can be done? If so, I would appreciate any help you can give me.

I'm using ArcGIS 9.3

Thank you.

4

Did you open the attribute table (right-click on layer and click the Open Attribute Table menu-item) and then copy/paste the selected records?

The first part of this answer takes care of the copy/paste steps: Exporting table from ArcGIS Desktop to Excel file?

You can also export the selected records to text or dbf and open in excel.

4

There are a number of tools/scripts available that will export to Excel directly from ArcMap. http://arcscripts.esri.com/details.asp?dbid=13194

Also, assuming you have Microsoft Office installed, the following method has worked for me.

  1. Create empty personal geodatabase (mdb)
  2. Export selected features into this new, empty personal geodatabase.
  3. Open up this personal geodatabase in MS Access, and the feature class created in step 2 should appear as a regular table. You should be able to export this table directly to Excel, or any number of other formats. You'll probably want to delete the geometry(SHAPE) column.
  • ahhh! Of course! Right in front of me. Thank you. – Mike Mitchell Dec 29 '10 at 19:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy