Importing a txt file into SQL Server with a where clause
<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>