Microsoft.Jet.OLEDB.4.0Standard (Excel)

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;
Extended Properties
="Excel 8.0;HDR=Yes;IMEX=1";

Connecting

This connection string (Standard (Excel) using Microsoft.Jet.OLEDB.4.0) 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.