title: How to SELECT from any spreadsheet in Excel File using OleDbDataAdapter
body: <p>I'm using <code>OleDbDataAdapter</code> to extract <code>DataSet</code> from excel file, but I have problems with <code>SELECT</code> statement inside</p>
  
  <pre><code>DataSet excelDataSet = new DataSet();
  using (OleDbConnection con = new System.Data.OleDb.OleDbConnection(connectionString))
  {
       con.Open();
       OleDbDataAdapter cmd = new System.Data.OleDb.OleDbDataAdapter("select * from [Name of spreadsheet]", con);
       cmd.Fill(excelDataSet);
       con.Close();
  }
  </code></pre>
  
  <p>If you see I have <code>"select * from [Name of spreadsheet]"</code>, but I need to get any spreadsheets, or for example 1st spreadsheet, but the name for this spreadsheet can be anything.</p>
  
  <p>How to specify it? Is it any special characters like <code>"select * from [%]"</code></p>