arcgis-10.5arcgis-9.3arcgis-desktopexcel
Is there a way to export a table with selected records to an Excel spreadsheet?
I was trying to export just to .txt file but ArcGIS gives me an error message.
An error occurred exporting the table
The other problem I have is with coordinates. I want them only with one locus after the comma, I mean like the format: xx xx xx,x not like I have now xx xx xx,xxx.
The version of my software is 9.3.
If you open the attribute table,
open an empty excel spreadsheet,
Select all or some of the records in the attribute table.
to select all the button in upper left gives this pulldown to accomplish that.
right click on the left edge (on a box).
copy selected.
Switch to the spreadsheet. right click in the upper left cell (just one cell)
ctrl+V (paste).
A way of converting an attribute table to a comma separated text file is to run the Table to Table tool. The location would be a folder such as c:\temp\mydata and the output table would be test.txt. If you set the field mappings then you can choose which fields get exported.
But you may get yourself into trouble, what happens if a text value contains a comma? Personally I would keep the attribute table in a structured format such as a DBase format as that enforces data integrity. If you have non-roman characters then they may get lost, so a unicode table such as a table in a personal geodatabase is best. Text formats may be simple and easy to understand but a database table takes away the pain...food for thought.
Best Answer
Do you receive the same error by copy/pasting records?
This is from memory, but if you right-click on the gray row indicator box, your menu should have "Copy Selected Records". Then you can paste directly into an Excel spreadsheet.
A caveat: if your selections are in a related table that are a result of a feature selection, you might actually have incorrect selections (you get rows in your related table that aren't actually related to any of your selected features and you could be missing others). One of my users discovered this issue, which appears intermittent. I did narrow down the issue to ArcMap. The geodatabase+custom ArcObjects test code works correctly. Our workaround: if our users need the related data for something important and the number of records is too large for them to visually inspect, we obtain the data from the database using a sql query. We haven't seen this issue with ArcGIS 10.
Update: You said you got the data into Excel. Are your DMS values in a text field? You might be able to parse the information that you need and round your decimal value. based on what I see in your screen shot, i came up with:
http://dl.dropbox.com/u/1156285/example.xls