VBA & SQL: INSERT TO... problem with date

[Guest]

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

 

[Bob Phillips]

Presumably the Access table allows nulls for birthday?

If so, just use

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

 

[Guest]

Thanks Bob,

the problem is that this code is in the middle of other code, so I should
check if the field is empty or not, etc...

is there any way to insert a Null value? For Text or number you just put two
single quotes ('') and that's it. For dates?

Thanks.

 

[keepITcool]

use the Null keyword.


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



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


Santiago wrote :

 

[Guest]

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