Combine/Merge Tables in Access 2010

The following is a very basic merge, it assumes the data structure is the same for all combined tables.

  1. Select the first table within Tables Pane
  2. Copy the selected table (CTRL+C)
  3. Paste the copied table into the Tables Pane (CTRL+V)
  4. The Paste Table As dialog will appears
  5. Ensure the Structure and Data option is selected, select OK
  6. Open the newly copied table in Design View (Right-click > Design View)
  7. Drop all AutoNumber fields, Primary Keys, and Foreign Keys
  8. Save the changes to the copied table
  9. Copy the new table (CTRL+C)
  10. Paste the new table into the Tables Pane (CTRL+V)
  11. The Paste Table As dialog will appear again
  12. Type the name of the table that will recieve the copied data
  13. Ensure the Append Data to Existing Table option is selected, select OK

Using this method Access provids no feedback on the results of the merge.

Quick and dirty!

about me

An information technology professional with twenty two year's experience in systems administration, computer programming, requirements gathering, customer service, and technical support.