title: Import/Update data from Excel to SQL Server
body: <p>I'm converting a database from Excel onto MS SQL server and am basically clueless.</p>
  
  <p>The Excel file has column headings of <em>GroupID, Name, Members, Remarks</em> </p>
  
  <p>The SQL table has the same fields.</p>
  
  <p>When I update the SQL some records are totally new, so need to be appended, others need a column or two updated, while most records need nothing at all.  So far I've taken the lazy way out &amp; truncated the file &amp; appended everything back in, but what's the <strong>proper</strong> way?</p>