Help combining 3 tables

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

Guest

Hi,

I have been trying to make an append query work for awhile and kinda gave
up. I want know how to combine three tables into one. Each table has a
primary key which can link all the tables as one. I am working with 150,000
rows of data. I would like to know what would be the best way to combine
these tables.

Is there a way to combine by column instead of by row?

Sarita
 
Can not you append the first table, then the second, and finally the third
table?

I do not understand you comment about "a way to combine by column."
 
You could maybe do it all at once, assuming the 3 Tables have identical
or similar structures, by defining a Union Query and then basing a
Make-Table Query on the Union Query, but that seems like more trouble
than it's worth, unless you expect to have to do it several times.

If you're considering appending only some of the fields, and then using
Update Queries to do the others, that seems like way more trouble than
it's worth. I suggest not trying to do that (although it would probably
work).

I think Karl's idea looks pretty good -- copy the 1st Table, then append
the 2nd Table to the copy, then the 3rd Table to that. This can be done
without the use of Queries, if the Tables have similar structures.
After copying the 1st Table, you can, in the Database Window, select the
2nd Table and choose "Copy", then right-click as if you were going to
paste it, but in the dialog box that appears, choose the option to
append the contents to a Table that you will name, and specify the copy
that you made of the 1st Table.

Oh, yes... be sure to back up your database first!

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Okay scratch my first Idea. My problem still remains that I am not sure how
to append them properly. When I attempt it before it would only update the
rows. I will try it first and let you know what I come up.

Sarita
 
I do not how your attempt to append results in updating rows.
What is the process that you are using?
Are you using an append query?
Are you trying to append the primary key? If the primary key is duplicated
then the records will not be appended.
Are you copying and then clicking on menu EDIT - Paste Append?
If you use a query please post your SQL statement.
 
Back
Top