AnsweredAssumed Answered

CSV Data - ArcMap 10.2 - working with Exponential/Mathematical Numbers

Question asked by timdunlevie on Jan 8, 2015
Latest reply on Jan 11, 2015 by moloneb

Hi all,


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 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?