Copy from one table to another

[vagelisr]

Hi to all

I have 4 tables.
1)Master_Header
2)Temp_Header
3)Master_Detail
4)Temp_Detail

The tables 1,2 and 3,4 is absolutely same

I want to copy the records from Temp tables to master tables and after this empty the temp tables

Any help is acceptable............

 

[Trevor G]

You should look to create 2 queries, first an Append Query to copy the records from the temp table to the main table, then create a Delete Query to delete the temp table, you can then create a macro to run both at once when you decide they need running.

 

[buyukkemal]

hello you can do so,
INSERT INTO table1 ( AA, BB, CC )
SELECT table2.AA, table2.BB, table2.CC
FROM table2;
AA,BB,CC === COLUMNNAME
I hope it function