Thanks!
......................................
Append records from one table to another table using an append query
Create a query that contains the table whose records you want to append to another table.
How?
In query Design view, click the arrow next to Query Type on the toolbar, and then click
Append. The Append dialog box appears.
In the Table Name box, enter the name of the table you want to append records to.
Click Current Database if the table is in the currently open database. Or click Another
Database and type the name of the database where the table is stored. Type the path if
necessary.
You can also enter a path to a Microsoft FoxPro, Paradox, or dBASE database, or a
connection string to an SQL database.
Click OK.
Drag from the field list to the query design grid the fields you want to append and any
fields you want to use for setting criteria. Also, you may or may not want to add the
primary key field if it has an AutoNumber data type. For more information, click .
If all the fields in both tables have the same names, you can just drag the asterisk (*)
to the query design grid. However, if you're working in a database replica, you'll need to
add all the fields instead.
If the fields you've selected have the same name in both tables, Microsoft Access
automatically fills the matching name in the Append To row. If the fields in the two
tables don't have the same name, in the Append To row, enter the names of the fields in
the table you're appending to.
In the Criteria cell for the fields that you have dragged to the grid, type the criteria
on which additions will be made.
For information on specifying criteria, click .
To preview the records that the query will append, click View on the toolbar. To return
to query Design view, click View on the toolbar again. Make any changes you want in
Design view.
Click Run on the toolbar to add the records.
Note To stop a query after you start it, press CTRL+BREAK.
Try an Append query.
