Standard (for versions 97 - 2003) using Excel 2007 ODBC
Connection string
This Microsoft Excel 2007 ODBC Driver connection string can be used for connections to Excel 97, Excel 2000, Excel 2002 and Excel 2003.
Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};
DBQ=C:\MyExcel.xls;