ASP.NET

private void insdata()
       {
           try
           {
               string filename = "~\\Documents\\" + ViewState["MissionCat"];
               string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(filename) + "; Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1;\"";

               // Create Connection to Excel Workbook
               using (OleDbConnection connection = new OleDbConnection(excelConnectionString))
               {
                   connection.Open();

                   OleDbCommand command = new OleDbCommand("Select [Mission] ,[Civilian] ,[Military] ,[Police]" +
                    ",[Unknown] ,[Non-UN] ,[Total] FROM [Sheet1$]", connection);

                   string sqlConnectionString = ConfigurationManager.ConnectionStrings["conn"].ToString();

                   //truncate the table before inserting new data.
                   SqlConnection cnntrunc = new SqlConnection(sqlConnectionString);
                   SqlCommand truntbleBU = new SqlCommand();
                   truntbleBU.Connection = cnntrunc;
                   string trunsqlBU = null;
                   trunsqlBU = "TRUNCATE TABLE MissionCatReport";
                   truntbleBU.CommandText = trunsqlBU;
                   cnntrunc.Open();
                   truntbleBU.ExecuteNonQuery();
                   cnntrunc.Close();

                   // Create DbDataReader to Data Worksheet
                   using (DbDataReader dr = command.ExecuteReader())
                   {
                       // Bulk Copy to SQL Server
                       using (SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConnectionString))
                       {
                           bulkCopy.DestinationTableName = "MissionCatReport";
                           bulkCopy.WriteToServer(dr);
                       }
                   }
               }
           }
           catch (Exception ex)
           {
               throw ex;
           }
       }