date cell in Excel is null

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top