Merge / Join tables access 2000

  • Thread starter Thread starter CB
  • Start date Start date
C

CB

Would appreciate easy way to join or combine 2 tables
created from query to create 1 table.

Each table has the same number and field names with some
different info within some fields. One table has primary
key the other without. Will I need to create primary key
for both tables, etc.

And how do you take a saved query and convert it to a
table.

Thanks much.
 
Would appreciate easy way to join or combine 2 tables
created from query to create 1 table.
Click to expand...

Either a UNION query (see UNION in the online help) or use an Append
query to append the records from one table into the other table.
Each table has the same number and field names with some
different info within some fields. One table has primary
key the other without. Will I need to create primary key
for both tables, etc.
Click to expand...

The resulting table should have a Primary Key obviously (*all* tables
should have a Primary Key). It needn't be an autonumber, just so it's
unique and stable. Is the PK in the table that has one an autonumber,
or something else?
And how do you take a saved query and convert it to a
table.
Click to expand...

By opening the query in design mode and using the Query menu option
(or the query type toolbar icon) to change it into a MakeTable query.
You'll be prompted for the name of the output table.
 
Back
Top