How to tell OleDb driver for excel to always read as text?

[justduick]

I am using the Microsoft.Jet.O LEDB.4.0 provider to read from an excel doc into my visual studio c# application... I know that using the property IMEX=1 will cause the reader to always read "intermixed " types as text. However, it appears that if the first cell in the column is a number and later cells are text, even with this property all cells are not interpreted as text. So does anyone know if in this situation there is a way to tell the provider to read all cells, no matter what, as text?

thanks.