trouble reading excel with ado.net

[Guest]

Whenever I try to read an excel sheet using ado.net, I keep getting this error

"Could not find installable ISAM. "

I tried what microsoft had to say on this link
http://support.microsoft.com/?scid=kb;EN-US;209805 but the problem still
persists.

Does anyone have any idea why?

 

[Guest]

Here is the code that's giving me trouble:

string connString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=C:\\Development\\CPRUtilities\\SeamusFile.xls" +
"Extended Properties=Excel 8.0;HDR=YES;";
OleDbConnection connection = new OleDbConnection(connString);

DataSet ds = new DataSet();
OleDbDataAdapter command = new OleDbDataAdapter("Select * from
[NonWeiss$]",connection);
connection.Open();

try
{
command.Fill(ds);
}
catch (Exception ex)
{
}

 

[Norman Yuan]

Is it for web app or Windows app?

If the connection string in your post is directly copied from your code,
then you probably missed a ";" between the end of *.xls file name and
"Extended...".

Here is the code that's giving me trouble:

string connString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=C:\\Development\\CPRUtilities\\SeamusFile.xls" +
"Extended Properties=Excel 8.0;HDR=YES;";
OleDbConnection connection = new OleDbConnection(connString);

DataSet ds = new DataSet();
OleDbDataAdapter command = new OleDbDataAdapter("Select * from
[NonWeiss$]",connection);
connection.Open();

try
{
command.Fill(ds);
}
catch (Exception ex)
{
}

Whenever I try to read an excel sheet using ado.net, I keep getting this error

"Could not find installable ISAM. "

I tried what microsoft had to say on this link
http://support.microsoft.com/?scid=kb;EN-US;209805 but the problem still
persists.

Does anyone have any idea why?