Connecting to Excel via ADO.net: ISAM driver error

[Markus Heid]

Hi,
I've got following problem:
I'm trying to open a excel sheet via a ado.net oledb connection. but as soon
as the function Open is called I'm getting an exception with following text:
"Could not find installable ISAM driver". Looking in the msdn I found
several issues to that problem. I checked the registry as described and
re-registered the dll but that was effectless.
Here's my code:
string sConnString =
"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=J:\\MyDir\\MyExcelFile.xls" +
/*+ ofdExcelSheet.FileName + */

";Extended Properties=\"Excel 8.0;HDR=Yes\"";

System.Diagnostics.Trace.WriteLine( sConnString );

System.Data.OleDb.OleDbConnection cn = new
System.Data.OleDb.OleDbConnection( sConnString );

cn.Open();



I'm using VS.NET 2003 and Office 2003

Does anyone have any expierences with that issue



Thanks in Advance

Markus

 

[Paul Clement]

¤ Hi,
¤ I've got following problem:
¤ I'm trying to open a excel sheet via a ado.net oledb connection. but as soon
¤ as the function Open is called I'm getting an exception with following text:
¤ "Could not find installable ISAM driver". Looking in the msdn I found
¤ several issues to that problem. I checked the registry as described and
¤ re-registered the dll but that was effectless.
¤ Here's my code:
¤ string sConnString =
¤ "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=J:\\MyDir\\MyExcelFile.xls" +
¤ /*+ ofdExcelSheet.FileName + */
¤
¤ ";Extended Properties=\"Excel 8.0;HDR=Yes\"";
¤
¤ System.Diagnostics.Trace.WriteLine( sConnString );
¤
¤ System.Data.OleDb.OleDbConnection cn = new
¤ System.Data.OleDb.OleDbConnection( sConnString );
¤
¤ cn.Open();
¤
¤
¤
¤ I'm using VS.NET 2003 and Office 2003
¤
¤ Does anyone have any expierences with that issue

I would say it's likely that your connection string is incorrect. Here is an example using C#:

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=e:\\My Documents\\Book2.xls;" +
"Extended Properties=" + (char)34 + "Excel 8.0;HDR=Yes;" + (char)34;


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Markus Heid]

You're right "Data Source" instead of "DataSource". And that was what I'm
searching for hours.

 

[William Ryan eMVP]

Your connection string looks like the problem. I have an example in C#
http://www.knowdotnet.com/articles/exceldatasource.html here but you have a
lot of / and \ that don't look like they belong.

HTH,

Bill

--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/
http://www.devbuzz.com/content/zinc_personal_media_center_pg1.asp