title: how can a DataSet be filled using multiple SELECT queries run against an Excel file?
body: <p>my command is something like this:</p>
  
  <pre><code>string command = "SELECT * FROM [SheetName1$]; SELECT * FROM [SheetName2$]; ...."
  </code></pre>
  
  <p>When I do </p>
  
  <pre><code>  DataSet set = new DataSet();
    using(OleDbDataAdapter adapter = new OleDbDataAdapter(command, connection))
    {
       adapter.Fill(ds)
    }
  </code></pre>
  
  <p>I end up with an empty DataSet (more specifically I end up with an exception that says Characters found after end of SQL statement).  However, if I use only one SELECT query this works fine.</p>