In previous versions I could just export as a .DBF file, open it with Excel and the convert it to an Excel file. However now in this version the .DBF file can no longer be open by Excel. I have also tried saving as a text file but to no avail.
Tell me more
×
Geographic Information Systems Stack Exchange is a question and answer site for
cartographers, geographers and GIS professionals. It's 100% free, no registration required.
|
|
You can still do this, although Excel has made it more difficult by breaking the loading sequence for associated .dbf's. Export normally. Open Excel on its own. Go to File -> Open, select 'All Files', and find the .dbf. |
|||
|
|
|
XTools Pro has a Export to Excel option that exists in the free tools available even after the 14-day trial period. I've been using that for years. You can export the attributes to Excel, or if you have Excel installed, you can just directly open up the attributes in Excel. |
|||
|
|
|
You can also drag and drop the dbf into Excel (at least Excel 2007/2010). Sometimes easier than doing this:
|
|||
|
|
|
The .dbf should open without any problems in excel, however, if it's a feature class in a geodatabase you can't get to the dbf. Option 1: If you have a license with X-Tools (maybe even the free version) you can export table to excel, which will launch the program automatically. Option 2: Export Data outside of the geodatabase (to a shapefile) and grab the dbf just like Chris.Leeney suggested. |
|||
|
|
