joining tables

M

martyn

how do you put one table into another? not with
relationships though. I have two tables and need to
combine the two so i can export just one table.
Many thanks
 
L

Liz

Do an Append Query. Append the data from one table into
the other. Whatever table you are Appending into will
need to have the same fields and field data types as the
Appending from table.

You can read more about Append queries in Help.

Good Luck!
 
M

martyn

do the tables have to match exactly, or just the name of
the columns, as the table that i want to append to hase
about 30 more columns
Many thanks
 
L

Liz

The tables don't have to match exactly, nor do the columns
have to have the same names but the fields you are
appending to and from have to have the same data types.
Be sure that you are appending the data into the correct
fields in the Appending To table.

Also, do you have primary keys on any of the fields and if
so will the append cause key violations?

For further info I would suggest a quick read through in
Help under APPEND QUERIES.

Good Luck!
 
S

Sandy Eastman

Use a query with UNION
** UNION requires same type and number of columns in each table
For more info look up UNION in help.

TABLE Customers UNION TABLE Suppliers;
 
P

Pavel Romashkin

You need to use a UNION query. Create a new query, switch to SQL view
and type:

SELECT * FROM Table1 UNION SELECT * FROM Table2

Fields must be the same (at least their number must be the same). If
they are different, use field names in place of * to make them the same.
Cheers,
Pavel
 
M

martyn

Worked great thanks!!!! :)
-----Original Message-----
The tables don't have to match exactly, nor do the columns
have to have the same names but the fields you are
appending to and from have to have the same data types.
Be sure that you are appending the data into the correct
fields in the Appending To table.

Also, do you have primary keys on any of the fields and if
so will the append cause key violations?

For further info I would suggest a quick read through in
Help under APPEND QUERIES.

Good Luck!
.
Click to expand...
 
Top