Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
ACC2000: How to Transfer Data from One Table to Another
Article ID: 209728 - View products that this article applies to.
This article was previously published under Q209728
Novice: Requires knowledge of the user interface on single-user computers.
To transfer data between two tables, you can create an additional field in one of the tables to store the common data, and then create an update query to accomplish the transfer.
CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.
This process can be illustrated using the sample database Northwind.mdb. The following example adds a ProductName field to the Order Details table, and then copies the ProductName field from the Products table based on the ProductID field.
NOTE: Typically, you do not duplicate the ProductName field because duplicate data does not indicate good database design.
To transfer data between two tables, follow these steps:
For more information about transferring data between two tables, click Microsoft Access Help on the Help menu, type update a table based on values in another table by using a query in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.