Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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
1  
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
add comment

2 Answers

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

share|improve this answer
add comment

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
add comment

Your Answer

 
discard

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.