Connecting Tech Pros Worldwide Forums | Help | Site Map

Appending Tables in Access

freeagent@ellsbury.com
Guest
 
Posts: n/a
#1: Nov 12 '05
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







Larry Linson
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Appending Tables in Access


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


<freeagent@ellsbury.com> wrote in message
news:gjjapvgbgkd3nvbqo73sddpibdt0jeuhuq@4ax.com...[color=blue]
> 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
>
>
>
>[/color]


andybriggs
Guest
 
Posts: n/a
#3: Nov 12 '05

re: Appending Tables in Access



Create an Append Query to append records from Table1 to Table 2, then
another to append Table 2 to Table 3 (or vice-versa, of course).



Hope this helps.


--
Andy Briggs
Elmhurst Solutions Limited
http://www.elmhurstsolutions.com


Posted via http://dbforums.com
Closed Thread