Insert missing value in numeric column through ado
 

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??