Problems with Microsoft.Jet.OLEDB.4.0 in windows server 2012


Due the error "The ‘Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine" using this library in a .net web app and SSIS package...

we have discover that this driver is not valid any more in this kind of 64 bits OS, so we have made a change in order to run the Excel Helper library in the ExcelSheetHelper.cs file: (attached on this comment)

string _xlsConString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=Excel 12.0";

so now both connection string _xlsConString and _xlsxConString runs the same driver (Microsoft.ACE.OLEDB.12.0)

Now app and packages works great, processing all kind of excel files.
More details in:


file attachments