<div>
I assume that you are using it like this:<br />
OleDbConnection con = new OleDbConnection(strConn);<br />
<br />
<br />

</div>


I assume that you are using it like this:
OleDbConnection con = new OleDbConnection(strConn);




<div>
Here's the code:<br />
OleDbConnection Conn = new OleDbConnection;<br />
Conn.ConnectionString = strConn;<br />
Conn.Open()<br />
<br />
Thanks,<br />
TALJr
</div>


Here's the code:
OleDbConnection Conn = new OleDbConnection;
Conn.ConnectionString = strConn;
Conn.Open()

Thanks,
TALJr

<div>
<div class="content wysiwyg-content">
I am having difficulty connecting to an Excel &nbsp;.xls file (used as a DB source) in .NET.<br />
<br />
When I try to connect using .NET and the following connection string I get an exception:<br />
<br />
string strConn = &quot;Provider=Microsoft.Jet.OL<wbr />EDB.4.0; Data Source = &quot;C:\data.xls; Extended Properties=&quot;&quot;Excel 8.0; HDR=YES; &quot;&quot;&quot;<br />
<br />
The exception says that the Microsoft.Jet.OLDDB.4.0 provider is not registered.<br />
<br />
I am using VS 2005, &nbsp;and Excel from Microsoft Office 2003. <br />
<br />
Does anyone have a fix for this or an alternative solution?<br />
<br />
&nbsp;I need to input the data in an Excel file, make changes and then output to an SQL Server 2005 table.<br />
<br />
Thanks,<br />
TALJr
</div>
</div>


I am having difficulty connecting to an Excel  .xls file (used as a DB source) in .NET.

When I try to connect using .NET and the following connection string I get an exception:

string strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source = "C:\data.xls; Extended Properties=""Excel 8.0; HDR=YES; """

The exception says that the Microsoft.Jet.OLDDB.4.0 provider is not registered.

I am using VS 2005,  and Excel from Microsoft Office 2003. 

Does anyone have a fix for this or an alternative solution?

 I need to input the data in an Excel file, make changes and then output to an SQL Server 2005 table.

Thanks,
TALJr

Fix for Exception when connecting to an Excel .xls file using .NET.?

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.