Setting up an OLE DB Excel connection
What we need is the following:
Exact name of OLE DB provider on the server hosting SQL Server.
If you don't know which drivers are installed, have a look here: Control Panel->Administrative tools->Set up odbc data sources (look at the description and name of the dll to find out if it's odbc or native OLE DB). If you don't see any native OLE DB drivers, please install it by downloading it here (http://www.microsoft.com/en-us/download/details.aspx?id=13255).
If SQL server is 64 bits then the OLE DB driver needs to be 64 bits as well.
If the MS Access Database engine does not work, try the Office System Driver: Data Connectivity Components ( http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734 )
---