date cell in Excel is null

[Guest]

Hi.

I hope somebody can help me.

I am trying to read an excel file via ADO.NET.

I have tried using a datareader and filled datatable (by oledbadapter).

My problem is that some cells with date format are being returned as null.

Can anybody offer some explanation and solution?

I am trying to avoid using automation (creating an excel process instance).
With it though, I have no problem reading the data...

Thank you.

 

[Bernie Yaeger]

Hi,

You say 'some cells' - then some must be being read correctly. Is there a
pattern to those that are being returned null, something that distinguishes
them from the other date cells?

Bernie Yaeger

 

[Guest]

Thank you but I found the answer already.
I just have to add the "IMEX=1" extended property to my connection string.

The full explanation is here in case anybody else encounters the
same problem:

http://support.microsoft.com/?id=194124