How do I Merge two tables?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two databases, crop 2004 and permittees 2004. Both tables have permit
numbers fields that match. I want to merge the two tables so that all the
info in crop 2004 is added to and matches the table in permittees 2004 by the
permit field. How can I accomplish this? I need to collate the information
from both tables. Please respond to (e-mail address removed)
 
Dear Dark Torture,

I am NOT really sure I understand your question. I AM really sure I am NOT
one of
the more knowledgeable posters to this newsgroup. But seeing as how your
message
has gone unanswered for several hours I will venture to take a stab at a
reply.
I believe what you will be wanting to do is to run an Update Query if I
understand you correctly.
To be clear, let's say you have 2 tables with Employee info on them. Each
has an Employee Id field and
in each the Id number correspond to the same name so for example, Ed is
employee 1 in both tables, and Peter is
employee 2, etc, etc.
Let's say table 1 for some reason is missing address info and table 2 has
the missing info. In the Relationships window, create
a relationship between the two tables via Employee Id. I hope you know how
this is done. Now create a new select query in query design view that
includes both tables. You would then include Employee Id field for table 1
(the one missing addresses), the address field from table 1 and the address
field from table 2. Now, still in Design view click the word "Query" in the
Menu Bar and select Update Query from the drop down list. In the query
design grid the words "Update to" will have appeard a row above "Criteria".
In the Table 1 Address field on the "Update To" row you would enter
[Table2].[Address]
This is telling MS Access that you want to update Table 1 Addresses with
corresponding info from Table 2.
Okay now to trigger this Action Query click the Exclamation Point on the
Toolbar in query design view. This is the "Run" button and hovering the
mouse pointer above it will verify same. Answer yes to confirm on the next
two warning windows that open.

Now, having said all that, I suspect the reason you didn't get a reply to
your question from anyone else is that they are all thinking it is a mistake
to merge two tables. They are all probably thinking that is the purpose of
queries. If you want to see information from two tables merged in one place,
build a select query with fields selected from both and leave your tables in
peace.

If you are uncertain how to proceed, ask more questions.

Edward J the unholy - user of Lookup Fields, Send Keys and Unsplit Databases
 
Back
Top