Question

求一个能把EXCEL批量导入SQL数据库的ASP程序代码!!!

求一个能把EXCEL批量导入SQL数据库的ASP程序代码!!! 能直接将EXCEL表的对应字段数据添加到MSSQL的表的相应字段!!! 要求完整代码!!!!

Answer 1

protected void Button1_Click(object sender, System.EventArgs e) { string XLS_Path=""; string XLS_Name = MakeFileName(); string fileExtName = ""; if(File1.PostedFile.ContentLength >0) { try { fileExtName = File1.PostedFile.FileName.Substring(File1.PostedFile.FileName.LastIndexOf(".")); if(fileExtName!=".xls"||fileExtName.Length<1) { Response.Write( ""); return; } File1.PostedFile.SaveAs(Server.MapPath("../uploadexcel/")+XLS_Name+fileExtName); XLS_Path =Server.MapPath("../uploadexcel/")+ XLS_Name+fileExtName; } catch(Exception ex) { Response.Write(ex.ToString()); } } else { Response.Write( ""); return; } string ConStr=System.Configuration.ConfigurationManager.AppSettings["ConnString"]; SqlConnection Conn=new SqlConnection(ConStr); string mystring="Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = '"+XLS_Path+"'"+";Extended Properties=Excel 8.0"; OleDbConnection cnnxls = new OleDbConnection (mystring); OleDbDataAdapter myDa =new OleDbDataAdapter("select * from [Sheet1$]",cnnxls); DataSet myDs =new DataSet(); try { myDa.Fill(myDs); } catch { Response.Write( ""); return; } if(myDs.Tables[0].Rows.Count<=0) { Response.Write( ""); return; } int []zjid=new int[myDs.Tables[0].Rows.Count]; string strSql = ""; string CnnString="Provider=SQLOLEDB;"+ConStr; OleDbConnection conn =new OleDbConnection(CnnString); OleDbCommand myCmd =null;