Excel data mismatch

[=?Utf-8?B?S3VtYXIuQS5QLlA=?=]

I am having a problem in reading the values from the excel sheet in ASP .Net.
I am using the following connection string to read values from rows from an
excel sheet into a dataset. One of the columns contains alpha-numeric values
i.e. ABCDE12345 When accessing the value of this cell it returns "" (empty
string).

I am using the following connection string:
string strConn="Provider=Microsoft.Jet.OLEDB.4.0;"+"Data
Source="+filepath+";"+"Extended Properties=Excel 8.0;";

I have tried adding combinations of the following also.
HDR=YES;IMEX=1;ImportMixedTypes=Text;

The exception I get after adding the above code with my above connection
string is "No installable ISAM".

Does anyone have experience with this problem?

--
Kumar.A.P.P
Software Engineer, Infosys Technologies Limited.
http://techaid.wordpress.com/

[Mark Rae [MVP]]

"Kumar.A.P.P" <Ku******@discussions.microsoft.comwrote in message
news:82**********************************@microsof t.com...

I am using the following connection string:
string strConn="Provider=Microsoft.Jet.OLEDB.4.0;"+"Data
Source="+filepath+";"+"Extended Properties=Excel 8.0;";

I have tried adding combinations of the following also.
HDR=YES;IMEX=1;ImportMixedTypes=Text;

Extended properties need to be surround in quotes:

string strConn = "Provider=Microsoft.Jet.OleDB.4.0;" + "Data
"Source=" + filepath + ";" + "Extended Properties=\"Excel
8.0;HDR=YES;IMEX=1;ImportMixedTypes=Text \"";
--
Mark Rae
ASP.NET MVP
http://www.markrae.net