Hello
The data
An access table with xyz data along with other attributes with decimal numbers (ex: 0.0186) saved as numeric, double, 10 decimal. This table contains 500 000 records.
What I�??m trying to do:
Import this table into ArcGIS to query, select etc, according to 3D location
The problem:
Once I import my data into ArcGis and created a shapefile, the numbers of my attribute are truncated/rounded to 0.
So far what I have tried:
I establish an OLE DB Connection with the Access database (mdb) that work fine. I can preview my data and all the number appears correctly i.e. with decimal places. If I directly add this table to ArcMap and display the xy data, again my data appears correctly with all the decimal place.
Now, I select �??create feature class from xy table�?� to create a shapeline. I add this shapefile to a blank arcmap and when I open the attribute table all numbers are now rounded to no decimal place. I checked the field properties of the attributes table and change the decimal places to 10 but it doesn�??t change anything
I have tried to change my data type in access but due to the table size I cannot.
I�??m far from being an expert but I know this have to do with the nature of the data; being store in a �??double�?� format. I have read a few post in this forum about this issue but I didn't found a way to work around this or solve this.
Please help I have been a this for days now
