title: Update Access Database using Excel - best approach
body: <p>I have an Access Database and an Excel spreadsheet with a few hundred lines of data to update into the DB.  Some of the fields in the Access database are not in the Excel spreadsheet.</p>
  
  <p>Is it best to write an Excel VBA script to update the Access DB or is there a better approach?</p>
  
  <p>I am not very familiar with Access and my VBA skills are rusty so any examples are appreciated.</p>
  
  <p>Some sample data, this is from the Excel:</p>
  
  <pre><code>    MN      File Identifier
  587034901   PN000352
  3248029409  PN000352
  3066978806  PN000456
  574565507   PN000477
  </code></pre>
  
  <p>MN would be the "unique key" in Access (I'm used to SQL).</p>
  
  <p>These will be updates and not inserts.</p>
  
  <p>Thanks.</p>