[dba-VB] OT?: How to load null date to SQL2000 from VB

Simply put, if I use a simple insert query:

Insert into tablename (field1, fielddate) values ("bob", '')
My table will show field1 = bob, and fielddate = 1/1/1900.

I've seen all kinds of .Net workarounds, but none work for VB6.0.
Any help is appreciated.  Thanks.