Moving Records to another Table

  • Thread starter Thread starter Margie
  • Start date Start date
M

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.
 
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.
 
Back
Top