protected void Button2_Click(object sender, EventArgs e)
{
string strpath = this.FileUpload1.PostedFile.FileName;
string str = "Provider=Microsoft.Jet.OleDB.4.0;Data Source=" + Server.MapPath("Lily.mdb");
OleDbConnection conn = new OleDbConnection(str);
conn.Open();
OleDbCommand cmd = new OleDbCommand("insert into sap_table (purchase_level,byd_sap) SELECT da,yy FROM [Excel 5.0;HDR=YES;DATABASE=" + strpath + "].[sheet1$]", conn);
cmd.ExecuteNonQuery();
Page.RegisterStartupScript("", "<mce:script type="text/javascript"><!--
alert('数据导入成功');
// --></mce:script>");
}