It depends upon what you need to merge. If the 2 tables are identical in
structure, use an append query or simply copy and paste the records from 1
to another. If the 2 tables contain related data with a matching key, add
the fields from the second table to the first then write a query which links
the 2 and does an update to the data in the new fields of the first table.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads http://www.datastrat.com http://www.mvps.org/access
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
