Bookmark and Share BitCoin Donate: 13t8gAWVpHP2ddxMp88d1NFpZjnFJC6UwK

Download the driver from microsoft at http://www.microsoft.com/downloads/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en (This is for the 2007 Office System Driver: Data Connectivity Components)
Connection Strings:
Excel ODBC Connection String
Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\MyFile.xls;DefaultDir=c:\temp;

Excel OLEDB Connection String
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyFile.xls;Extended Properties='"Excel 8.0;HDR=Yes;IMEX=1"'

If those don't work, this one seems to work for me:
"Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=C:\\temp\\test.xls; Extended Properties=Excel 8.0;"