Pls need help w/merging two tables

[Guest]

I need help with merging two tables with same fields same rows. However,
some fields maybe filled for some records . I would like to merge the two
main tables. I would like to know how I can achieve this without too much
clean up. Can this be done and so how. Thank you in advance for any help
you can give me.

 

[Guest]

quick & dirty : make a copy of your DB so you are not playing with the real
data....then approach this via Query.

When you are in a Query in design mode there will be a Query choice up in
your menu bar. Select that and you have two approaches to work with. Try
first an Append Query and also experiment with a Make Table Query....use F1
for help...

but I think you will get the hang of it with a little experimentation....

 

[Guest]

When I do an Update Query it ask what I want to update with. I don not want
to add anything except what is in the other database. The two databases have
same fields but will need to be merged. Can I ask it to pull the data in the
specific fields from table 1 to update table 2? Thanks in advance