Transfer Data from one Table to another

V

Van T. Dinh

Try an Append Query to append Records from the Source Table to the
Destination Table.

Check Access Help on Append Query.
 
Top