Load master table based on query of "staging table"

vbnetcoder
vbnetcoder used Ask the Experts™
on
I have a  "master table" that is set up the same way as a "staging" table.  I want to load master based on the result of a query.  What is the best way to do that?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017
Commented:
Use an append query.  Select from the staging table using your selection criteria and append to the master table.

Author

Commented:
ty

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial