View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ST ST is offline
external usenet poster
 
Posts: 8
Default 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??