I am trying to import csv files in ArcGIS to do a join. However, some of the fields are identified as double, some as long and some as long. Therefore the join results in bunch of columns with NULL value. I am not sure why it happens.
I tried to save the numbers with three decimal position in excel as csv format but when I open the number after decimal does not change. Since I have more than 256 columns, I can't save it as xls/xlsx file.
I think using python could be a solution. Any other thoughts? Python experts, could you please provide me any help. Attached is the screenshot..