MERGE TWO TABLES IN ACCESS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DAWHELP - 25 Jul 2006 18:36 GMT

I want to simply merge two tables into one. Field headings are the same in
each table.

Reply to this Message

Jeff C - 25 Jul 2006 18:46 GMT

What you want to do is "APPEND" data from one table to the other. Decide
which table you want to "put data into".

open a new query and put "the other" table into it.

Bring down all the fields from the table into your query. on the menu above
choose "query" then "APPEND". Choose the other table and run the query, all
the records will then be appended or added to the table you chose.

Signature

Jeff C
Live Well .. Be Happy In All You Do

> I want to simply merge two tables into one. Field headings are the same in
> each table.

Reply to this Message

DAWHELP - 25 Jul 2006 19:50 GMT

jeff something went wrong. they appended but three times each . help

> What you want to do is "APPEND" data from one table to the other. Decide
> which table you want to "put data into".
[quoted text clipped - 7 lines]
> > I want to simply merge two tables into one. Field headings are the same in
> > each table.

Reply to this Message

Jeff C - 25 Jul 2006 20:27 GMT

You must have clicked the red astorisk running the append query three times.
What do you want to do now? You can run a "find duplicates" query. Go to
queries, select new query, choose "find duplicates" which will start a wizard
allowing you to select the table with all the records in it. The wizard will
build a query that returns all the duplicates and then you can delete them.
Does this help you?

Signature

Jeff C
Live Well .. Be Happy In All You Do

> jeff something went wrong. they appended but three times each . help
>
[quoted text clipped - 9 lines]
> > > I want to simply merge two tables into one. Field headings are the same in
> > > each table.

Reply to this Message

Klatuu - 25 Jul 2006 19:24 GMT

Create an Append Query and append one to the other.

> I want to simply merge two tables into one. Field headings are the same in
> each table.

Reply to this Message