View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMan ExcelMan is offline
external usenet poster
 
Posts: 7
Default 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.