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!
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!