OLE DB Driver issues
Hint: This is a good OLE DB driver for Excel files on a 64 bits system: MS ADE drivers ( http://www.microsoft.com/en-us/download/details.aspx?id=13255). Select download and then choose the 64 bits version.
Enable the option Ad hoc distributed queries in order to allow OpenRowset function with ole-db driver specification. https://msdn.microsoft.com/en-us/library/ms187569.aspx