title: How to use the OleDbDataAdapter Fill method to only add a determined number of rows?
body: <p>I want to add rows in a DataSet, but only a specific number of rows (in order to avoid the "Too many fields defined." exception). This is what I have tried so far:</p>
  
  <pre><code>OleDbCommand command = new OleDbCommand(@"SELECT TOP 100 FROM [" + SheetName + "]", connection);
  </code></pre>
  
  <p>Exception: The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.</p>
  
  <pre><code>OleDbCommand command = new OleDbCommand(@"SELECT * FROM [" + SheetName + "] LIMIT 100", connection);
  </code></pre>
  
  <p>Exception: Syntax error in FROM clause.</p>
  
  <p>I also tried this that I got from another <a href="https://stackoverflow.com/questions/8016658/select-top-700-from-objectaer-work-only-in-sqlserver-2005-but-2008">site</a></p>
  
  <pre><code>OleDbCommand command = new OleDbCommand(@"SELECT TOP 100 * FROM [" + SheetName + "]", connection);
  </code></pre>
  
  <p>Exception: Too many fields defined.</p>
  
  <p>I have no idea what else to try, any suggestions?</p>