How do i move records from one table to another ?

  • Thread starter Thread starter filnigeria
  • Start date Start date
F

filnigeria

I need to copy the whole of one table (which is a temporary one) to a main
table withiin the same database
i want to do this before i delete the temporary tables
i have the delete scripts
now all i need is how to move them from one tableto another before i delete
them

HELP

Jordan
 
Assuming the two tables have the same data types:

strSQL = "INSERT INTO MainTable (Col1,Col2,Col3,Col4) " & _
"SELECT TCol1,TCol2,TCol3,TCol4 FROM Temp"
DoCmd.RunSQL strSQL
 
Back
Top