Moving Records to another Table

[Margie]

Is there a way to move records from one table to another
in Access 2000 without using code? I want to completely
remove the records from the original table and place them
in another table. I have appended, updated, and deleted
but can't figure out how to move.

 

[Douglas J. Steele]

AFAIK, there's no move capability. You'll have to continue appending from A
to B, then deleting from A.

Of course, this is a rather unusual requirement. Maybe if you describe why
you're trying to do it, someone will be able to suggest an alternative.