Thanks KIC, I believe I tried that and did not work, but maybe the problem
was another one. For "UPDATE" SQL command Null seems to work, so should also
work for "INSERT INTO" command.

I'll try again and recheck. Thanks

"keepITcool" wrote:


use the Null keyword.


"INSERT INTO TABLE(NAME, SURNAME, BIRTHDAY)
VALUES('Johnny', 'Walker', Null)"



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Santiago wrote :

How can I insert a blank field into a date field in Access?

For example, I have a Table with the fields Name, Surname,
Birthday(Date).

I'd like to insert a new record based on an excel sheet using ADO &
SQL String. If the birthday field is empty I get an error. The value
is ## because the field is empty.

SQLstring = "INSERT INTO TABLE(NAME, SURNAME, BIRTHDAY)
VALUES('Johnny', 'Walker', ##)"

Thanks