EXCEL数据导入数据库的另一种方式

var fileResult = openFileDialog1.ShowDialog();
if (fileResult == System.Windows.Forms.DialogResult.OK)
{
var fileName = openFileDialog1.FileName;
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES;\"");
OleDbDataAdapter da = new OleDbDataAdapter("select * from [Sheet1$]", conn);
da.Fill(dataTable);
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = dataTable.DefaultView;
progressBar1.Maximum = dataTable.Rows.Count;
label1.Text = dataTable.Rows.Count.ToString();
}

foreach (DataRow dataRow in dataTable.Rows)
{
index++;
if (dataRow[].ToString() == null && dataRow[].ToString().Trim() == "")
{
continue;
}
User user= new User();
//省略代码
context.ArchivesBases.Add(archivesBase); if (index >= && index % == )
{
context.SaveChanges();
//释放持久层已经存在数据
GC.Collect();//垃圾回收器
context = new DAL.TodaySoftHRAMSContext();
}
}