Move a record from one .mdb to another

[T. Wise]

I have one record in one file that I want to delete from the first file and
move into the 2nd. How do I do this?

 

[fredg]

I have one record in one file that I want to delete from the first file and
move into the 2nd. How do I do this?

As long as the tables have the same structure, you can use an Append
query to add the record to the other database, then use a separate
Delete query to remove the record from this database.

In query design view, click on Query + Append
The wizard will walk you through it.

Then create the delete query the same way:
Click on Query + Delete

Make sure the criteria is identical in both queries.

 

[T. Wise]

Thanks, but I found a simpler way: Paste Special, then choose either Text or
CSV.