title: No value given for one or more required parameters in Sheet Excel
body: <p>An error appear when i want to import sheet excel in C# application, </p>
  
  <p>ERROR is "<strong><em>No value given for one or more required parameters</em></strong>".</p>
  
  <p>I'm using c# with MS excel . This is my code</p>
  
  <pre><code> OpenFileDialog openFileDialog1 = new OpenFileDialog(); 
          openFileDialog1.FileName = "";
          openFileDialog1.Filter = "Excel File Sheet |*.xls; *.xlsx";
          try
          {
              if (openFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
              {
  
                  string path = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + openFileDialog1.FileName +   ";Extended Properties=\"Excel 8.0;HDR=Yes;\";";
                  OleDbConnection conn = new OleDbConnection(path);
                  OleDbDataAdapter da = new OleDbDataAdapter("SELECT Date, PF, [Agent Name], TL, Supervisor, [Sum Under], [Sum Over], [Out of Adherence], Sch, Sum([Out of Adherence %]*100), Sum((100-(100*[Out of Adherence %]))) AS [Adherence % Daily] FROM [Sheet1$] GROUP BY Date, PF, [Agent Name], TL, Supervisor, [Sum Under], [Sum Over], [Out of Adherence], Sch, [Out of Adherence %]", conn);
                  DataTable dt = new DataTable();
                  da.Fill(dt);
                  dataGridView1.DataSource = dt;
  
  
              }
          else
                  return;
  
          }
          catch(FieldAccessException ex)
          {
              MessageBox.Show("ERROR" + ex);
          }
  </code></pre>
  
  <p>Please Help Me for this Error,</p>
  
  <p>Thank you for all..</p>