2

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.

comparison of Excel and geodatabase values

4

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.

\hklm\software\wow6432node\microsoft\jet\engines\excel

typeGuessRows change to 0

2

A couple things to try:

  1. save the Excel file in DBase (.dbf) format,
  2. or save as CSV file,
  3. and/or reorder the data so that the value of the first row contains a letter.

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.