Excel 97
Excel file with header row (for versions 97 - 2003)
Data Source =c:\myExcelFile.xls;HDR=yes;Format=xls;
Excel file without header row (for versions 97 - 2003)
Data Source =c:\myExcelFile.xls;HDR=no;Format=xls;
.NET xlReader for Microsoft Excel connection strings
Excel 2000
Excel file with header row (for versions 97 - 2003)
Data Source =c:\myExcelFile.xls;HDR=yes;Format=xls;
Excel file without header row (for versions 97 - 2003)
Data Source =c:\myExcelFile.xls;HDR=no;Format=xls;
Excel 2002
Excel file with header row (for versions 97 - 2003)
Data Source =c:\myExcelFile.xls;HDR=yes;Format=xls;
Excel file without header row (for versions 97 - 2003)
Data Source =c:\myExcelFile.xls;HDR=no;Format=xls;
Excel 2003
Excel file with header row (for versions 97 - 2003)
Data Source =c:\myExcelFile.xls;HDR=yes;Format=xls;
Excel file without header row (for versions 97 - 2003)
Data Source =c:\myExcelFile.xls;HDR=no;Format=xls;
Excel 2007
Excel file with header row
Data Source =c:\myExcelFile.xlsx;HDR=yes;Format=xlsx;
Excel file without header row
Data Source =c:\myExcelFile.xlsx;HDR=no;Format=xlsx;
Excel 2010
Excel file with header row
Data Source =c:\myExcelFile.xlsx;HDR=yes;Format=xlsx;
Excel file without header row
Data Source =c:\myExcelFile.xlsx;HDR=no;Format=xlsx;
Excel 2013
Excel file with header row
Data Source =c:\myExcelFile.xlsx;HDR=yes;Format=xlsx;
Excel file without header row
Data Source =c:\myExcelFile.xlsx;HDR=no;Format=xlsx;