Two free tables have similar but not identical structure, with one field that autoincrements present in both. One table is empty and needs to receive data from the other table bit retain old value of field that autoincrements.

What is the simplest way to turn autoincrement off momentarily and then back on?

Thank you.

Alex