When import table from excel some data were loss. I was trying to change field type but I can't solve this error. I have attached an example image to show the problem.
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
ArcGIS uses Microsoft technology to read Office formats, Excel and Access. The default is to read the first 8 rows to determine column datatypes. Changing this registry key forces the entire table to be read first. The infered datatypes and widths are much more accurate, especially for .csv.
typeGuessRows change to 0
A couple things to try:
The import isn't very smart and when it sees a number value for the field, it makes that field's type a number. Reordering may make it interpret the field as text. Notice that the field containing 'NA' values is interpreted as text. See if the first row contains 'NA'. If so, reordering such that the first rows has text in both fields should force it to interpret both fields as text.