title: how to import multiple excel sheets into 2 sql server tables?
body: <p>Am having one excel file with 2 different worksheets as fundmodelrate and project.Now I want to import these 2 different sheet values into 2 different sql tables(k2_fundmodelrate,k2_project).I can able to do import only if am working with 1 sheet and and 1 table,but I want two sheets values to be imported on two tables at the same time on button click event.
  My code below:</p>
  
  <pre><code>private String strConnection = "Data Source=kuws4;Initial Catalog=jes;User ID=sa;Password=******";               
          protected void btnSend_Click(object sender, EventArgs e)
          {
  
              string path = fileuploadExcel.PostedFile.FileName;
  
              string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\fmr.xls;Extended Properties=Excel 12.0;Persist Security Info=False";
  
              OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);
  
              OleDbCommand cmd = new OleDbCommand("Select * from [FundModelRate$]", excelConnection);
              //OleDbCommand cmd1 = new OleDbCommand("Select * from [FundModelRate$],  [Project$]", excelConnection);
              excelConnection.Open();
              OleDbDataReader dReader;
              dReader = cmd.ExecuteReader();
              SqlBulkCopy sqlBulk = new SqlBulkCopy(strConnection);
  
              sqlBulk.DestinationTableName = "K2_FundModelRate";
             // sqlBulk.DestinationTableName = "K2_Project";
              sqlBulk.WriteToServer(dReader);
              excelConnection.Close();
          }
  </code></pre>