Updating ms access table
Tip: Back up your database before you run an update query.
You cannot undo the results of an update query, and making a backup helps make sure that you can reverse your changes if you change your mind.
I've tried cmsjr answer, and I thought it was that easy, but it isn't. I'm bad with SQL, but the join statements make me zone [email protected] I'm glad to know that this helped you.
In both cases, you use the SQL statement INSERT INTO to accomplish the task.
In Microsoft Access 2007, I'm trying to update about 6000 records from one table with values from another table, but I'm having problems. When you have finished adding your tables, click on the Close button.
Actually I am trying to update the Bot table MFG with the Big table MFG when Big. In this example, we've selected the Big and Bot tables.
Unlike the Find and Replace dialog box, an update query lets you: As a best practice when creating an update query, first create a select query that identifies the records that you want to update, and then convert that query to an update query that you can run to update the records.
By selecting data first, you can verify that you’re updating the records you want before you actually change any data.