Cant Update Boolean and Dates To NULL with ADO

E

ExcelMan

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA works in orignal but fails in copy of database 1
Updateing a record with a Null value field, fails? 5
Can a boolean ever be set to null? 18
Wildcard Filtering on ADO Recordset 1
.SpecialCells, xlCellTypeConstants, and a null value 2
Remvoving Null Items from an ADO Recordset prior to sending to Exc 3
Boolean Nulls 9
return ADO record set from Add-In? 1

Top