my attempts to upload records with an empty date field resulted in SQL Server filling the date field with 01/01/1900. I don't want that so I've been trying to update the records with a blank date. All my attempts have been rejected with complaints about converting the string to a date.

Anyone know the way to do it?