![]() |
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. |
All times are GMT +1. The time now is 05:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com