Data Source =c:\myExcelFile.xls;HDR=yes;Format=xls;
This connection string (Excel file with header row (for versions 97 - 2003) using xlReader) can be used for connections to
Excel 2000, Excel 2002, Excel 2003 and Excel 97.
Start over in the connection string reference index.
You can also get help in the Q&A forums where you can ask your own question.
The kb articles contains how-tos and instructions and you can search for anything if you're not sure were to look.