Changes

Jump to: navigation, search

Export from ArcGIS to Excel

269 bytes added, 15:59, 17 October 2014
no edit summary
{{Under construction| Images missing}}When the text fields are written with a non-Latin alphabet it is not possible to use the dbf-file because that file format does not support UTF-16. The work-around is to copy from ArcMap to Excelwhich in ArcMap 9.3.1 was possible to do with keyboard shortcuts like Ctrl + A. In ArcMap 10.1 these keyboard shortcuts do not work in the Attribute table and therefore the menus must be used.
[[Image:UTF 16 dbf.png|400350px]]
<div >
''How In the dbf-file looks likethe non-Latin characters are not readable''
</div>
<br/># Open the Attribute table in ArcMap.[[Image:xxx1UTF 16 attr table.png|400px350px]]
<div >
''How In the Attribute table in ArcMap 10.1 the non-Latin characters looks like''</div># Click on the Table icon and choose ''Select All'' in the menu[[Image:xxx2.png|400px]]<div>''Table button and the grab handleOK''
</div>
# <ol start="2"><li> Click on the Table button and choose ''Select All'' in the drop-down menu. <br/><br/>[[Image:Table grab buttons.png|400px]]<li> Hold down ''Shift'', right-click on the first row's grab handle and choose ''Copy Selected'' in the drop-down menu.# <li> Paste into an Excel file<br/>[[Image:xxx3UTF 16 Excel.png|400]]
<div >
''How the final result looks like''
</div>
</ol>
{{NavBox Technical Notes}}
[[Category:NAA]]
6,632
edits

Navigation menu