Help combining 3 tables

L

luscioussarita

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
 
K

KARL DEWEY

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."
 
V

Vincent Johns

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.
 
K

KARL DEWEY

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.
 
Top