3

I want to save some attribute tables in a file format that Excel can read. Currently I'm using the tool Table to dBASE in Modelbuilder, but when I open the files in Excel it shows some errors in characters like "ç", "à", "õ". For example, what should appear like "Vila Chã" actually appear like "Vila ChÒ"

I need a format that accepts this type of characters correctly. How can I work around this situation? The solution should be a geoprocessing tool that can be used in a model, like "Table to Excel"

I've installed the tool "Table to Excel" and this is the error I'm getting:

enter image description here

There's some problem with encoding, but how can I solve this?

6

Use "Table To Excel Tool" instead. It outputs the attribute table directly to xls format.

If it s not available with 10.0, download it from:

http://www.arcgis.com/home/item.html?id=cbb7b0ea4c014dd8bc2832f9be1e2d03

  • 1
    I think that tool only comes in 10.2 and higher, so he will have to download it – ed.hank Oct 15 '15 at 12:21
  • Where do I put the extracted files from zip? And how I use the tool? It's giving me errors when I use the tool, maybe I'm not doing it properly – AndM Oct 15 '15 at 13:37
  • @AndM extract the files and browse to its location via catalog window in ArcMap or Arccatalog. – Farid Cheraghi Oct 15 '15 at 13:41
  • It's what I'm doing. I've updated the question with a print of the errors that I'm obtaining. – AndM Oct 15 '15 at 13:45
  • I have tested it with unicode characters and works fine. What is the source of your data (e.g. shapefile)? if it is shapefile what is the encoding? – Farid Cheraghi Oct 15 '15 at 13:54
1

Here is a link to a tool called table 2 excel. It should do what you want and it works within a model

https://geonet.esri.com/thread/97530

http://blogs.esri.com/esri/arcgis/2010/08/10/working-with-microsoft-excel-in-arcgis-desktop/

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.