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

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

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

Presumably the Access table allows nulls for birthday?

If so, just use

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


--
HTH

Bob Phillips

"Santiago" wrote in message
...
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

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

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.

"Bob Phillips" wrote:

Presumably the Access table allows nulls for birthday?

If so, just use

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


--
HTH

Bob Phillips

"Santiago" wrote in message
...
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

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

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

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

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