Connecting to Excel via ADO.net: ISAM driver error

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
Tue Jun 01 08:45:19 CDT 2004

On Tue, 1 Jun 2004 11:47:36 +0200, "Markus Heid" <markus.heid@logasys.com> wrote:

¤ 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 ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Markus
Tue Jun 01 08:54:05 CDT 2004

You're right "Data Source" instead of "DataSource". And that was what I'm
searching for hours.
"Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
news:8q1pb0l9t8fas76o07r1ptgoj1f925vh1u@4ax.com...
> On Tue, 1 Jun 2004 11:47:36 +0200, "Markus Heid" <markus.heid@logasys.com>
wrote:
>
> ¤ 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 ~~~ pclement@ameritech.net
> Microsoft MVP (Visual Basic)

William
Tue Jun 01 09:01:16 CDT 2004

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
"Markus Heid" <markus.heid@logasys.com> wrote in message
news:uYqw517REHA.3420@TK2MSFTNGP11.phx.gbl...
> 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
>
>