Come for the ArcGIS, stay for the Microsoft Office.
Friday, April 29, 2011
Exporting ArcGIS 10 attribute table to Excel 2007
Open attribute table. Table options in upper left (button looks like bulleted paper) -> export -> export: all records; output table: save as type dBASE Table in desired folder.
Rumor is that Excel 2010 will fix that, but reviews have been mixed. I'm able to open my dbf in 07 though, by right clicking and selecting Excel as the program to use and walking Excel thru it. I hope Future Excel will make it easier!
My ArcGIS refueses to give me any options as to what I save as, saving as a LOCK file. It may have something to do with my university's license, has anyone overcome this problem?
this doesn't work since excel 2007 doesn't seem to be able to read .dbf files. thank you microsoft!
ReplyDeleteRumor is that Excel 2010 will fix that, but reviews have been mixed. I'm able to open my dbf in 07 though, by right clicking and selecting Excel as the program to use and walking Excel thru it. I hope Future Excel will make it easier!
ReplyDeleteyou mean export -> save as .txt file -> name the file .csv -> open in excel
ReplyDeleteMy ArcGIS refueses to give me any options as to what I save as, saving as a LOCK file. It may have something to do with my university's license, has anyone overcome this problem?
ReplyDelete