I would like to know the code to co

[paulbradley]

I would like to know the code to copy data from one table, out it in another and delete what was in the original table.

The field names are the same in both tables.

Many thanks.

 

[jrbarnett]

use two separate queries with the following SQL code:

insert into table2 select * from table1

to copy the data across, and

delete from table1

to clear the first table.

Just replace "table1" with the source table name and "table2" with the name of the destination table.

John

 

[paulbradley]

Cheers!