C#.NET Excel and OLEDB Connection String
<p>I am trying to read data from Excel file into my windows application. </p>

<p>Connection String :</p>

<pre><code>provider = Microsoft.Jet.OLEDB.4.0; Data Source = "Excel File"; 
Extended Properties =    \"Excel 8.0; HDR = Yes; ImportMixedTypes = Text;
Imex = 1;\" 
</code></pre>

<p>With this connection string I am able to read data from Excel file <strong>even though Microsoft office - Excel is not installed onto the computer</strong>. But some how, my program is not compatible with this connection string. </p>

<p>Connection String which I am using right now is </p>

<pre><code>provider = Microsoft.ACE.OLEDB.12.0; Data Source = "Excel file"; 
Extended Properties = "Excel 12.0; HDR = Yes; Imex = 1;
</code></pre>

<p>This connection string is compatible with my program but <strong>it only works on the computer which do have Microsoft office - Excel install.</strong> </p>

<p>Can anyone suggest me where I am making mistake.</p>

<p>Thanks.</p>
