Bookmark and Share

Download the driver from microsoft at (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;"