ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cant Update Boolean and Dates To NULL with ADO (https://www.excelbanter.com/excel-programming/276784-cant-update-boolean-dates-null-ado.html)

ExcelMan

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