title: Import Excel Spreadsheet into Existing MS Access Tables
body: <p>I have an Access database.  Here is the setup for a few tables.</p>
  
  <p>id - companyID (autonumber) PK, company (text), firstName (text), lastName (text)</p>
  
  <p>category - companyID (number) combined PK with category, category (text)</p>
  
  <p>salesmen - companyID (number) combined PK with code, code (text)</p>
  
  <p>There is a 1-many relationship between id and category and between id and salesmen.</p>
  
  <p>If I have a spreadsheet with columns of company, firstName, lastName, category1, category2, category3, salesman1, salesman2, how could I import the columns into the appropriate tables?</p>
  
  <p>My first idea was to import the spreadsheet and then append company, firstName and lastName to the id table.  Then I would join the imported spreadsheet with the id table to create a new table with all of the spreadsheet columns plus the auto generated companyID.  Then I could append companyID and category1 to the category table.  Then do the same for category2 and 3 and so on.</p>
  
  <p>This seems really complicated if I have a lot of spreadsheets to import.  Also, the person who will be importing the spreadsheets isn't a programmer, so she wants it to be as user-friendly as possible.</p>
  
  <p>Is there a better way to import these spreadsheets?</p>
  
  <p>Thanks!  </p>