1

I import an Access 2000 database through ArcCatalog. When I complete the process and check the attribute table, the values come not as decimals as they are in the database but as integer numbers. Why is that?

I have done this in the past successfully but now it is not working properly. Does it have to do with the decimal separator being a dot and not a comma? Does ArcGIS understand . as decimal point?

Process:

  1. Excel file import to Access, save as Access 2000
  2. ArCatalog connect database Microsoft Jet 4.0
  3. open ArcMap and refresh ArcCatalog
  4. take the database sheet and drop it on the table of contents
  5. display xy data
  6. data export data

And this is basically it. ArcGIS shows it as a double.

I am using ArcGIS 10.2 for Desktop.

  • 3
    Would you be able to include the precise steps that you performed in your question, please? That way it should be possible to repeat them without guessing. – PolyGeo May 5 '15 at 12:44
  • 2
    What type of fields does ArcGIS show in the personal geodatabase (e.g. float, double, short, text, etc)? – Aaron May 5 '15 at 13:02
  • Process: Excel file--> import to access, save as access 2000, arcatalog connect database microsoft jet 4.0 , open arcmap refresh arccatalog, take the database sheet and drop it to the table of contents, display xy data, data export data and this is basically it. It shows double – dimitris May 5 '15 at 13:17
  • Dot vs comma may depend on a localization setting. I believe you can set it to either, but I imagine if you have it set one way and your data is the other, it might not work. Have you considered trying to go directly from Excel to Arc (Excel to Table tool, or just adding it)? What is the end goal/format? Note that while personal geodatabase files use the Access format, they do have some special properties so a mdb created from Access may not work as expected if trying to use it as a personal geodatabase. – Chris W May 5 '15 at 22:47
  • excel works fine, but when it comes to large amount of rows access should be the only solution. the final goal is to map one of the attributes but if the values are rounded, then there is no point. for example there are some values 0,3 and they become 0 in the attribute. these represent costs, so 0 is just fault. – dimitris May 6 '15 at 9:39

Your Answer

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

Browse other questions tagged or ask your own question.