Create a standard SELECT query to retrieve the columns from TABLE2 using the
Query Builder. Then, in design view, on the menu Query | Append and enter
the name of TABLE1.Click the ! button on the Toolbar to run it. Repeat for
all the other tables.
Question: Will the records be uniquely identified if you just append them? I
ask because databases with that kind of duplication often use the tables
themselves as part of the identification of data -- if that is the case,
then you probably need to add a field to identify what the table name used
to identify before merging the data with Append Queries.
Larry Linson
Microsoft Access MVP
<fr*******@ellsbury.com> wrote in message
news:gj********************************@4ax.com...
Help!!
I am a complete Access newbie and I have to concatenate about 30
tables into one large table. All these tables have the same column
headings as each other.
For example, I have TABLE 1 which contains COLUMN1, COLUMN2, COLUMN3
...
and I have TABLE2 which contains COLUMN1, COLUMN2, COLUMN3 ...
and I want to produce TABLE3 where TABLE3 contains every row in TABLE1
and every row in TABLE2.
How can I do this?
Many thanks for any help you can give me!!
Graham