It is called Three-valued logic

https://en.wikipedia.org/wiki/Three-valued_logic

I do not understand enough in order to convince you, but I believe it is a way to deal with logical operations once you introduce the...

"Hello" = NULL does not result in a FALSE - it results in NULL.

likewise NOT(NULL) is neither TRUE nor FALSE, it is NULL

AFAIK all the strategies to speed up reading Excel involve finding ways to avoid using the COM model.

You can cause excel to save the data as .cvs and then read...

Yes. If you can guarantee that the spreadsheet will be in .xlsx form it makes things a lot simpler. Remember, an .xlsx document is really just a suite...

You'll have to clarify a little.

My most simpleminded reading of your request sounds like you want all the contents of all the cells (including some description of the cell formats)...

I would like to hear a SQL philosopher/historian explain how this situation came about. It seems such a violation of language orthogonality - lying in wait to create bad...

A programmer produces value, a seller produces money. Money wins every time!

Two bytes per character may be how Unicode is implemented in SQL Server - but code elements of one through four bytes are used in various definitions of Unicode. ...

Computer-as-infrastructure makes more sense to me than computer-as-protagonist. The computer of Tron was the best. I always thought Dumont was supposed to be Steve Wozniak and Sark was Steve...