Excel 2007 ODBCStandard (for versions 97 - 2003)

Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};
DBQ
=C:\MyExcel.xls;

Connecting

This connection string (Standard (for versions 97 - 2003) using Excel 2007 ODBC) can be used for connections to Excel 2000, Excel 2002, Excel 2003 and Excel 97.

Articlesread all »

Not the right connection string for you?

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.