VBA Null value

VBA data type date and number cannot hold Null value, but database can. Try to set data type to variant in VBA instead.