« How can we access the Internet without a land line?
How can I delete duplicated records in an Access Query? »

How to merge two tables in Access 2000?

I have two tables from a customer. Table A and Table B have same # of rows and same # of columns (each columns having same data type and same name). The customer wants to update Table A records to match Table B records. Is there a way to do that?

Try this website, it might help you.

This entry was posted on Sunday, November 29th, 2009 at 8:36 pm and is filed under access 2000. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “How to merge two tables in Access 2000?”

  1. gatorstarhd Says:
    November 30th, 2009 at 2:02 am

    This is assuming that there is a Primary Key column in each table that has a unique ID for each row that you can match on:

    Open a query window, open up the SQL pane, then use this:

    UPDATE TableA
    SET TableA.FirstName = TableB.FirstName,
    TableA.LastName = TableB.LastName,
    TableA.PhoneNumber = TableB.Phone Number
    FROM TableA.PrimaryKeyColumn INNER JOIN TableB.PrimaryKeyColumn
    References :

  2. starsdelite Says:
    November 30th, 2009 at 2:38 am

    Try this website, it might help you.
    References :
    http://www.bcschools.net/staff/AccessHelp.htm

Leave a Reply