protected void Button_upload_Click(object sender, EventArgs e) { string str = Server.MapPath("files1/" + FileUpload1.FileName); //string str = Server.MapPath("files/" + FileUpload1.FileName); FileUpload1.SaveAs(str); StringBuilder Connection123 = new StringBuilder(); Connection123.Append(@"Provider=Microsoft.Jet.OLEDB.4.0;Mode=ReadWrite|Share Deny None;Data Source="); Connection123.Append(str); Connection123.Append(";Extended Properties='Excel 8.0;HDR=YES;'"); //string constr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath(FileUpload1.FileName) + ";" + "Extended Properties=Excel 8.0;"; //Create Connection to Excel Workbook OleDbConnection connection = new OleDbConnection(Connection123.ToString()); OleDbCommand command = new OleDbCommand("Select * FROM [IP_Phone$]", connection); connection.Open(); // Create DbDataReader to Data Worksheet OleDbDataReader dr = command.ExecuteReader(); // SQL Server Connection String string sqlConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString(); SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConnectionString); bulkCopy.DestinationTableName = "dbo.finish"; bulkCopy.WriteToServer(dr); connection.Close(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)