title: Importing a txt file into SQL Server with a where clause
body: <p>I have a <code>.txt</code> file which is 6.00 GB. It is a tab-delimited file so when I try to load it into SQL Server, the column delimiter is tab. </p>
  
  <p>I need to load that <code>.txt</code> file into the database, but I don't need all the rows from the 6.00 Gb file. I need to be able to use a condition like </p>
  
  <pre><code>select * 
  into &lt;my table&gt; 
  where column5 in ('ab, 'cd')
  </code></pre>
  
  <p>but this is a text file and am not able to load it into db with that condition. </p>
  
  <p>Can anyone help me with this?</p>