joining tables

  • Thread starter Thread starter martyn
  • Start date Start date
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
 
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!
 
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
 
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!
 
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;
 
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
 
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...
 
Back
Top