格外注意第二种的写法,Provider那里是Ace,Extended Properties那里有'
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
![ExpandedBlockStart.gif](https://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif)
1
string
strConn
=
"
Provider=Microsoft.Jet.OleDb.4.0;
"
+
"
data source=
"
+ Application.StartupPath.ToString() +
excelFile
+
"
;Extended Properties='Excel 8.0; HDR=NO; IMEX=1'
"
;
//
此连接只能操作Excel2007之前(.xls)文件
2
3 string strConn = " Provider=Microsoft.Ace.OleDb.12.0; " + " data source= " + Application.StartupPath.ToString() + excelFile + " ;Extended Properties='Excel 12.0; HDR=NO; IMEX=1' " ; // 此连接可以操作.xls与.xlsx文件
2
3 string strConn = " Provider=Microsoft.Ace.OleDb.12.0; " + " data source= " + Application.StartupPath.ToString() + excelFile + " ;Extended Properties='Excel 12.0; HDR=NO; IMEX=1' " ; // 此连接可以操作.xls与.xlsx文件
HDR=YES 有两个值:YES/NO,表示第一行是否字段名,默认是YES,第一行是字段名
IMEX=1 解决数字与字符混合时,识别不正常的情况