Standard using Microsoft Excel ODBC Driver

Connection string

This Microsoft Excel ODBC Driver connection string can be used for connections to Excel 97, Excel 2000, Excel 2002 and Excel 2003.

Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\MyExcel.xls;
DefaultDir
=c:\mypath;

SQL syntax "SELECT [Column Name One], [Column Name Two] FROM [Sheet One$]". I.e. excel worksheet name followed by a "$" and wrapped in "[" "]" brackets.