title: How to import excel spreadsheet into access and cross reference two tables
body: <p>I have the following two Access tables</p>
  
  <pre><code>Employees
  id          Name
  1           bob smith
  2           james bird
  3           jane big
  
  
  Events
  id         emp_id        Notes
  1          1             fell down the stairs
  2          3             paper cut in the break room
  </code></pre>
  
  <p>I also have the following Excel file that I would like to 'suck' (import) into the Events table. The problem is the data needs to be correlated on the name/emp_id field and I'm not sure the best way to do this. </p>
  
  <pre><code>Excel_sheet
  
  Employee Name       Notes
  bob smith           feel asleep while driving 
  </code></pre>
  
  <p>The access table uses references to the Employees table, whereas the Excel sheet is using names. What are some options for me to bring this Excel sheet into Events table and convert the names (bob smith) into their associated id's from the Employees table? </p>