title: SQL Server Update table columns with a text file
body: <p>Below is a table store in database:</p>
  
  <pre><code> ID     Age     SectionID
   111    29       NULL
   100    30       NULL
  </code></pre>
  
  <p>To update Column Age with with a text file(see below for sample data)</p>
  
  <pre><code> ID     Age     SectionID
   111    29       231
   100    30       456
  </code></pre>
  
  <p>The text file comes without the column names. 
  I tired using the import wizard but seems its adding all the columns to the table again. I only need to add the SectionID column to the table. Can anyone tell me how to select the settings to make that happen? Thanks!!!!!!</p>