|
Posted by Ted on 08/08/06 19:42
I solved the problem with errors (item #1 in my previous post) by more
carefully specifying the data type of the input file columns. But this
leads to an equally serious problem. All the nulls in that column are
silently converted into zero. This represents a major distortion of
the meaning of the column. For this column, zero carries a very
different meaning from null. Worse, since the column had many records
in which the value was zero, it is not possible after the insert to
recover the nulls!
How can I tell the data import wizard to preserve my nulls?
Ted
Navigation:
[Reply to this message]
|