Is there a way to merge one access table into another access table?

  • Thread starter Thread starter deltadoll
  • Start date Start date
D

deltadoll

I am trying to merge a access table into another table. I
assume I can cut and paste, but is there another solution?
 
Hi doll (I've always wanted to say that<g>)

The answer is "Yes, a query". If you want to copy records from one table
into the other, you need an append query.

If you want to copy data from fields in one table into fields in the
coresponding records in the other, you need to create an update query
that joins the two tables.

Make a copy of the database (so you can experiment safely), and then go
to the Help contents page and look for "Create an append query" and the
other query topics. If you need more help later, post a question in the
"getting started" forum, microsoft.public.access.gettingstarted.
 
Back
Top