title: SQL Server: importing from Excel, only want the new entries
body: <p>The task is to have SQL Server read an Excel spreadsheet, and import only the new entries into a table. The entity is called <strong>Provider</strong>.</p>
  
  <p>Consider an Excel spreadsheet like this:</p>
  
  <p><img src="https://i.imgur.com/tYHcU.png" alt="alt text"></p>
  
  <p>Its target table is like this:</p>
  
  <p><img src="https://i.imgur.com/E9sPp.png" alt="alt text"></p>
  
  <p>The task is to:</p>
  
  <ul>
  <li>using 2008 Express toolset</li>
  <li>import into an existing table in SQL Sever 2000</li>
  <li>existing data in the table! Identity with increment is PK. This is used as FK in another table, with references made.</li>
  <li><strong>import only the new rows from the spreadsheet!</strong></li>
  <li>ignore rows who don't exist in spreadsheet</li>
  </ul>
  
  <p><strong>Question:</strong>
  How can I use the SQL 2008 toolset (Import and Export wizard likely) to achieve this goal? I suspect I'll need to "Write a query to specify the data to transfer".</p>
  
  <p>Problem being is that I cannot find the query as the tool would be generating to make fine adjustments.</p>
  
  <p><img src="https://i.imgur.com/6zMsW.png" alt="alt text"></p>