MS Access - combine tables

• • Reply

  17 years ago

  by bjk

  bjk

  Dearborn Heights, MI, United States

  Joined 18 years ago

  Hello, I have 3 ms access databases that have identical table structures but different data that I want to combine into one database.  Anyone have any idea on how to do that?  Thanks....
  

  
  

  Report abuse
• • Reply

  17 years ago

  by Sacko

  James Saxton

  Nottingham, England, United Kingdom

  Joined 18 years ago

  3 very simple sql statements.
  

  
  If tabe1 is your new table with the same structure and table2 , table3, table4 are your three tables
  

  
  

  
  Insert into table1 (select * from table2)
  Insert into table1 (select * from table3)
  Insert into table1 (select * from table4)
  

  
  

  
  you may not need the brackets.
  

  Report abuse
• • Reply

  17 years ago

  by bjk

  bjk

  Dearborn Heights, MI, United States

  Joined 18 years ago

  Thanks, I didn't think of that... You Rock!

  Report abuse