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.

I have an excel file with missing values encoded as blanks and I want this excel file to be converted into DBF but with the conversion process, the blanks (missing values) become 0.

The reason I am doing this is because I want to perform interpolation but because of the missing values becoming 0 the interpolation becomes wrong.

My question is how to treat missing values as without deleting the point shapefile and still proceed with interpolation.

share|improve this question

1 Answer 1

up vote 3 down vote accepted

If you export your Excel sheet to a geodatabase table, the blank values will remain blank, they won't be converted to 0.

One of the ways you can do this is by right-clicking the Excel sheet in the Catalog > Export > To Geodatabase (single)...

enter image description here

share|improve this answer
    
how do I do that? my apologies for inconveniences. –  user2543 Jun 18 at 7:33
    
See updated answer. –  GISGe Jun 18 at 7:41
    
Hi, I tried to do that but it seems that blank values became 0. –  user2543 Jun 18 at 8:02
    
Hi, What I did is not to save the file in a folder but inside a GDB and export it as GDB (Single). Thank you thank you. –  user2543 Jun 18 at 8:18

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.