Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I insert a date with an icon (calendar) insert | Excel Discussion (Misc queries) | |||
insert row problem | Excel Discussion (Misc queries) | |||
Automatically Insert DATE, so that DATE will NOT change | Excel Worksheet Functions | |||
Insert\Name\Apply.... problem | Excel Worksheet Functions | |||
copy insert problem | Excel Programming |