I think I mostly understand "null", "blank", "empty"...
The data I import to ARC is coming from Access.
Access is getting its tables from imports of Excel spreadsheets.
Usually, the "blanks" are true blanks in Excel..They have never contained data, but the possibility exists that they did and are now "empty".
Access doesn't seem to mind, and brings in the data. I see "empty" cells in the resulting tables, which is what I want and expect..
But upon import to ARCmap (add data as a route event) the cells that were "blank" in Access now have a 0 (zero) in place. That is undesirable an incorrect in terms of my data...
ARCmap identifies the blanks as "null". (It should identify them as something else, maybe blank, empty?..but not NULL, which ends up being represented as a 0).
Is there some check you can suggest that I can run to ensure that my resultant attribute tables will come into ARCmap with "blanks" instead of 0 ?
Edited by Bob J., 28 August 2008 - 09:41 AM.