cell in Excel with Date format is read by ADO.NET as NULL
Posted on 2004-11-28
My problem is the title itself.
I have tried to read an excel file using ADO.NET (as opposed to automation, which forces me to create an instance of an excel process).
Using a data adapter, I call the Fill() method and pass a datatable (most examples on the internet feature passing a dataset).
In the datatable, I am able to read the cells whose values has a string format.
But somehow, the cells with date format are null when I try to read it.
Did I miss some setting?
Should I set something in the datatable variable before using it?
Or do I really have to use a dataset instead? This should not matter, right?