I typed this question once already, hit preview, and somehow never got the preview and lost what I typed. It has been that kind of a day.

So here is my quick overview then I am going shopping. I am using OLE DB to select from an excel spreadsheet. It has over 15000 rows and 33 columns. Sometimes even when a cell is not null, it is returning a null value. If I just do a "select * where [termination date] is not null", for example, it will return no rows even though I can see with my own eyes that sometimes termination date is not null. If I select * where [termination date] is null, I get every single one of the 15000+ rows. Is Excel or Ole DB choking on the nulls for some reason?