This is doing my head in...
I have a simple .CSV file: X (easting), Y (Northing), DataValue (e.g. 1.52E-26, 1.20E-21, 8.69E-22, etc..)
If I drag this file from Catalog it gives the DataValue field "double" format and makes all values zero.
I've tried using the excel to table tool, I've tried saving as a .txt file...no luck.
Opening this .csv file in MapInfo Professional works perfectly....i.e. holds all the mathematical values.
Why is ArcMap so difficult when it comes to a simple .csv file ??
Am I doing something wrong?
If you open the CSV file in excel, a schema.ini is created initialy. You can edit this to define the data types. The file schema.ini is usually with a "hidden' attribute so you may not see it unless your folder settings allows it.
I have a similar but perhaps reverse problem. I have some polygon data in a .gdb file which has centroid Long Lat in decimal degrees eg 151.2348, -33.98114. When I export to a shape file, the .dbf file component of that has truncations of the Long Lat eg 151.235, -33.9811. I then want to pull that data back into ArcGIS after doing some manipulaton in Excel.The Lat truncation is not much of a problem at the scale I am working at (a 2 km zone around a central point) but the Long shows up as dots arranged as vertical lines.
Has anyone else experienced this and found a solution?