title: Importing csv file to SQL Server Management Studio and updating existing entries
body: <p>I'm running SQL Server 2012 and have a database with about 20,000 entries.
  I need to update a few columns for about 5,000 of them.</p>
  
  <p>I have the columns in a csv and it basically looks like this:</p>
  
  <pre><code>ClientNumber    ClientName              TaxYear       OutputFileField
  9455            James Bond and Company   2016          \local\cndps\93985.esx
  </code></pre>
  
  <p>I need to update the first 3 columns based on the 4th column match</p>
  
  <p>So for instance I need to update the above to be</p>
  
  <pre><code>ClientNumber    ClientName              TaxYear       OutputFileField
  1111            Luis Fandora            2044          \local\cndps\93985.esx
  </code></pre>
  
  <p>I tried importing thru SQL Server Management Studio, but that did not work.</p>
  
  <p>Any help would be appreciated.</p>