title: Reading Excel file - No value given for one or more required parameters
body: <p>UPDATE:</p>
  
  <p>after updating the correct path, I'm getting the new error which says
  <code>"External table is not in the expected format."</code></p>
  
  <p>I'm not sure what is wrong with this code and I'm trying to read the excel sheet and below is my code and getting the following error.</p>
  
  <pre><code>OleDbConnection oledbConn = new OleDbConnection();
  string path =  Path.GetFullPath(Server.MapPath("~/InformationNew.xlsx"));
  
  oledbConn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties='Excel 12.0;HDR=YES;IMEX=1;';");
  
  oledbConn.Open();
  OleDbCommand cmd = new OleDbCommand();
  OleDbDataAdapter oleda = new OleDbDataAdapter();
  DataSet ds = new DataSet();
  cmd.Connection = oledbConn;
  cmd.CommandType = CommandType.Text;
  
  cmd.CommandText = "SELECT [epic],[desc] FROM [Sheet1$]";
  oleda = new OleDbDataAdapter(cmd);
  oleda.Fill(ds); //&lt;&lt;&lt;ERROR
  </code></pre>
  
  <blockquote>
    <p>An exception of type 'System.Data.OleDb.OleDbException' occurred in
    System.Data.dll but was not handled in user code</p>
  
  <pre><code>Additional information: No value given for one or more required parameters.
  </code></pre>
  </blockquote>