I execute an SQL statement "INSERT INTO ... VALUES ...", but if one of the values is null string ("") then SQL fails. What can I do for this?
I am using VB6, ADO 2.7 and Access 2000.