OleDB returning DBNull for numeric cells
Hi,
I'm using OleDBConnection in a .NET app to read data from
Excel. I'm able to read everything except when a cell has
numeric value and the column has alphanumeric data. I get
DBNull when it encounters a numeric value. I'm sure many
people have seen this. Does anyone know how to address
this issue?
Thanks,
Paul
|