.net, excel, extended properties and dbnull
 

I have a column of data that is suppose to have decimals
in it. I am trying to trap for when the user puts
something else in there like text. When I run my tests,
I get dbNulls for the value instead of the text.

I've seen other postings for this and have added extended
properties using IMEX=1. Still get dbNulls. Any other
ideas? Here is my connection string:

string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" + saveLocation + ";Extended Properties='Excel
8.0;IMEX=1'";

(Also tried this with double quotes around the extended
properties)

Using Windows XP with ALL the latest patches. Have ALL
the JET 3.5, 4.0 drivers WITH service patches.

..NET is 2003(ADO) using OLEDB connection.

Thanks