title: SQL OleDBCommand selecting Excel Columns
body: <p>I'm using OleDBCommand to select some data in an Excel sheet I have. I have One column that has lists of data (column J) and every column after that either (columns K - AG) has a 1 or 0 depending on a relationship. So it's basically a graph plotted with 1 or 0. I want to use a SQL command to select every entry in column J where there is a 1 plotted in a column I choose. For example, say I want to look at the column J to K relationship. Then I would want to pull all data from J where columns J and K have a 1. 
  I am unsure of how to specify columns in SQL. I have currently:</p>
  
  <pre><code>OleDbCommand command = new OleDbCommand("select * from [Master$J0:J20] , connection);
  </code></pre>
  
  <p>I would need a WHERE clause after that to specify, where K0:K20 = '1' right? Or something like that. I can't get it. </p>