AnsweredAssumed Answered

Field Type Mismatch when merging excel files

Question asked by Prof25 on Mar 28, 2015
Latest reply on Apr 4, 2015 by Prof25



I am attempting to use the merge tool to combine nine excel files that I have imported into ArcGIS 10.3. When I did this, I got the error message "Failed on input OID could not write 'N/A' to output field Air_Temp." I went to the GDB and checked out the data type listed for this field (I got the data from someone else) and noticed that it was "double". I then realized that N/A is sprinkled throughout the data in all nine files.


What is the best way to deal with N/A and the resulting type mismatch when trying to merge these excel files?