VBA code for Select All Record, Copy and Paste Append

[onti44]

Can someone help me how is VBA code for append all records from a
access table into in other access table like Select All Record, Copy
and Paste Append in Edit menu.
Thanks very much.
I work with Access 200

 

[Steve Schapel]

Onti44,

The basic concept here would be to use an Append Query for this. Make a
Query in design view that gives you the data you want to put into the
other table. Make it an Append Query (select Append from the Query
menu). Run the query (click the toolbar button with the red [!] icon).
If you want to automate the process with a macro, you would use the
OpenQuery action.

Having said that, it is a very unusual request. Normally it would not
really be valid to be copying data from one table to another. Are you sure?