Database Engine 2010 Redistributable
There is a bug in the documentation at the download page.
The documentation says:
1.If you are the user of an application, consult your application
documentation for details on how to use the appropriate driver.
you are an application developer using OLEDB, set the Provider argument
of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”
you are connecting to Microsoft Office Excel data, add “Excel 14.0” to
the Extended Properties of the OLEDB connection string.
The "Excel 14.0" is the issue.
It should be "Excel 12.0".
Her are a few connection strings to provide full context.
// Old School Jet, been around for a while
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=’C:\MyOldSchoolFile.xls';Extended Properties=’Excel 8.0;HDR=NO;IMEX=1;';"
//Newer version with xslx
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=’C:\MyXlsXFile.xlsx';Extended Properties=’Excel 12.0 Xml;HDR=NO;IMEX=1;';"
//Newer version, any xls file
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=’C:\AlmostAnyExcelVersionFileRunningUnder64BitOS.xls';Extended Properties=’Excel 12.0;HDR=NO;IMEX=1;';"
Don’t take the above as absolute truth. But it should draw attention to the issue (if you’re experiencing it), and help with some more google (errr. bing) searches.
Here are some other phrases which might lead you here.
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered
( Trying to read an excel file on a 64 bit O/S? The purple string above should work for you under a 64 bit O/S. )
"Could not find installable ISAM"
( This might show up because of the "14.0" vs "12.0" bug mentioned above )