xlReaderExcel file with header row

Data Source =c:\myExcelFile.xlsx;HDR=yes;Format=xlsx;

Connecting

This connection string (Excel file with header row using xlReader) can be used for connections to Excel 2007, Excel 2010 and Excel 2013.

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.