肯定需要进行版本的判断。
" Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = " + fileName + " ;Extended Properties=Excel 8.0";这是03的
" Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = " + fileName + " ;Extended Properties=Excel 8.0";这是03的
connStrs.Add("Provider = Microsoft.ACE.OLEDB.12.0 ; Data Source = " + fileName + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=1;\"");
connStrs.Add("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = " + fileName + ";Extended Properties=\"Excel 8.0;HDR=No;IMEX=1;\"");
foreach (string connStr in connStrs)
{
ds = GetDataSet(connStr, sheetSet);
if (ds != null && ds.Tables[0].Rows.Count > 0) break;
}
return ds;