Oledb connection string formats for different Excel versions

Excel 2000 ~ The format of the 2003 oledb connection string is as follows:
Provider = Microsoft. Jet. oledb.4.0; Data Source = 'excel file path'; extended properties = 'excel 8.0; HDR = Yes'

The connection string format of oledb in Excel 2007 is as follows:

Provider = Microsoft. Ace. oledb.12.0; Data Source = 'excel file path'; extended properties = 'excel 12.0; HDR = Yes'

 

Excel2000-2003:

Oledbconnection excelconn = new oledbconnection ("provider = Microsoft. jet. oledb.4.0; Data Source = "+ filepath +"; extended properties = 'excel 12.0; HDR = yes; IMEX = 1 '");

Excel2007:
Oledbconnection excelconn = new oledbconnection ("provider = Microsoft. ace. oledb.12.0; Data Source = "+ filepath +"; extended properties = 'excel 12.0 XML; HDR = yes; IMEX = 1 '");

Note: filepath is the Excel file path. When importing the excel2007 file, excel2007 must be installed on the machine; otherwise, an error will be reported.