| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cant Update Boolean and Dates To NULL with ADO
I'm using ADO to run a SQL Update on an Excel table. I want to set all the
values in a set of records to NULL. This seems to work fine on text and numeric fields, but Boolean and Date fields fail to take the Set FieldName = NULL command. Anybody know why and if there is a workaround or maybe some parameters for me to set? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update dates annually | Excel Worksheet Functions | |||
| Update 2009 dates to 2010 dates | Excel Discussion (Misc queries) | |||
| Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
| Count number of days between dates BUT IF null to current date | Excel Worksheet Functions | |||
| No update of dates | Excel Discussion (Misc queries) | |||
Hybrid Mode
