Transfer data from one table to other. 2

[miller1975]

Hello All,
How do you move/transfer data from one table to other using a query assuming both tables have same field structure.

 

[dhookom]

Use an append query.

I trust you have a good reason to keep more than one copy of a record and/or have more than one table with the same or similar structure.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[willir]

Duane is correct, two for two.

To create an append query, from the menu...
- Insert -> Query
- Select Design view
- Add your table or tables
- Create a query
- Convert to an Append query, from the menu, Query -> Append
- Indicate which fields in the source table will be appended in the target table.
- View the test results, View -> Datasheet
- Toggle back to design or SQL view
- If satisfied, run the update

Always a good idea to have a backup plan before running a large update.

If you are trying to update just one record, or a select few records, you can use the Append query created with the above as a template in SQL view to be used with VBA code.

Richard