insert a missing value in a numeric field

[shailesh.tewari]

I want to insert a csv file in an access database.For some numeric
fields I am geting missing values in csv file.How can I insert a
missing value in the access.I do not want to insert 0(zero) and it is
not allowing me to save ' ' ( which becomes string).

Any quick code /solution??

 

[Joseph Meehan]

I want to insert a csv file in an access database.For some numeric
fields I am geting missing values in csv file.How can I insert a
missing value in the access.I do not want to insert 0(zero) and it is
not allowing me to save ' ' ( which becomes string).

Any quick code /solution??

Well numeric values run from - infinity to zero to + infinity. Take you
choice.

I suspect you want to use null. so the value will be blank, but not
zero. Is that correct?

 

[shailesh.tewari]

You are correct.I want to insert null .How?

 

[Joseph Meehan]

You are correct.I want to insert null .How?

You can try using an update query where the value is "Null" no quotes.

Be sure to try this on a copy first and make sure you have a select
query so it does not null all your data.