导入EXCEL

 //导入EXCEL
  public void ImportExcel(string file)
  {
  //string file = "d:\\123.xls";
  string excelStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + file + ";Extended Properties=Excel 8.0;";
  DataSet ds = new DataSet();
  using (System.Data.OleDb.OleDbConnection cn = new OleDbConnection(excelStr))
  {
  using (OleDbDataAdapter dr = new OleDbDataAdapter("SELECT * FROM [sheet1$]", excelStr))
  {
  dr.Fill(ds);//先导入到DataSet
   
  }
  }
  //然后插入数据库操作,insert...

   
  }