Ado.net access excel, ado. netexcel

Ado.net access excel, ado. netexcel

Class 1: OleDbConnection...

2 connection string:

Provider = Microsoft. ACE. OLEDB.12.0; Data source1_excelpath.xlsx}; Extended Properties = "Excel 12.0 Xml; HDR = NO; IMEX = 1 ;"

Note: 1). The connection string can access excel2013

2). If the first line is the header, HDR = YES. If the first line is not the header and the data is directly the data, HDR = NO.

3). The engine uses the scan method to confirm the Data Type of each column. IMEX should indicate the maximum number of rows scanned each time, ranging from 1 to 16. The default value is 8.

3. Table Name in excel:

1). [sheetName $]

2). [sheetName $ + region name], for example, [sheetName $ A1: B3]

Select * from [Sheet1 $ A1: B3]

Select * from [Sheet1 $]