how do I move records to another access database

[Nancy]

I have entered many records in the wrong access database. Do I have to
re-enter each one or can I move them without affecting existing data in
correct database?

 

[Allen Browne]

Use an action query to add the records to the desired database. You can then
delete them from the original one.

Create a query. In query design view, choose Append on the Query menu.
Access pops up a dialog asking what table to append to, and gives you the
option of selecting a different database file if that's what you need.