Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |