MS Access: Merge Tables

Instructions:

        1        Open Access 2007/2010 and open the database that contains the tables to be merged. Go to the "Create" tab and click "Query Design."

        2        Double-click the table that you want to merge. This will be your source table. After the selection has been made, click the "Close" button. The selected table will appear in the top half of the query designer.

        3        Double-click the asterisk that appears at the top of the table list of fields to select all of the table's fields and move them to the query design grid (bottom half of the query designer).

        4        Click the "Home" tab and then click "Design View." Click the "Append" button on the "Design" tab. You'll be asked if you want to append the data to the current database or a different one. Import the data to the current database by clicking "Current Database." From the "Table Name" box, select the target table. Click "OK."

        5        Move your mouse pointer to the top of the Access window and click the "Run" button (look for the red exclamation mark). You'll receive a message that you're about to append "x" number of rows to the target table you selected in the previous step. Click "Yes" to run the query and append the data.

Read More

Read more: How to Merge Tables in Access 2007 | eHow.com http://www.ehow.com/how_7328212_merge-tables-access-2007.html#ixzz1JWv2Ng8L