Combining multiple tables via queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to combine 12 tables within an MS Access database. There are a
large number of records (18300 ish) but all have a unique Ref Number. Some
headings are the same for all source tables but some are unique to a specific
table.

Should I use an append query or a make-table query? How do I create a table
with all the different columns? How do I populate this table with data from
each of the source tables?

Thanks for your help!
 
If this is a one off exercise you would probably be best creating a
destination table by hand and then creating 12 separate append queries to
copy data from each source table into this new table.

Regards
 
Back
Top