Reading Numeric column in excel as text .

[unitecsoft]

I am trying to read an Excel sheet to my program using OleDbDataAdapter into datatable , this is working fine except that if the excel column is text and taken into string field in the datatable its read as blank . anyone came across such a case . I am using ,NET 2.o framework with visual studio 2005 - C# . thankx

[unitecsoft]

Actually , if the first data cell in the column is numeric , the full column is read as numeric and any text in the same column is read as blank . and if the first data cell is text then the full column is read as text and any numeric cell in the same column is read as blank . I have columns with mixed data , some numeric only and some are string . any hints ?

[Ashfield]

In fact by default it ooks at the first 8 rows (odd number, really) and decides by that. Its a right pain, the last time I had this problem I ended up converting to csv and reading that.

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP