Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When import table from excel some data were loss. i was try to change field type but i cant solve this error. I have attached an example image to show the problem. enter image description here

share|improve this question
related to How to force ArcGIS to recognize a text field in a CSV file? which should help – Stephen Lead Aug 7 '12 at 0:36

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

share|improve this answer

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.

share|improve this answer
Thank u Sean. Its very useful your answer – RajGovind Aug 8 '12 at 4:27

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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