I have a VB-script in Excel that saves some values in to an Access Database. I have some trouble with cells that are Empty. The values are both text and numbers. In the db the number fields are set to Required=NO and the Text fields Allow Zero Length=YES. I still get an error in the VB-script saying "Data type conversion error" (Run-time error '3421') when a value is Empty.
I wonder if there is a way of telling Excel to generally accept empty values. The sheet is quite big (range a1:i77) and the values varies from time to time.
Can someone please help me with this?!
Please tell if you need more info.