In VB6, How Do I Move Records From One Access2K Table To Another Table 1

[Hiccup]

My setup is VB6 connected to an Access2K mdb via an Adodc.

My Access database has two Tables with identical Fields. The Tables are named "TEMP" and "PERM". I need to move all of the Records from the "TEMP" Table to the "PERM" Table when a cmdButton on my VB Form is clicked.

The result of the click event should result in no Records in the TEMP Table and the Records that were there appended to the PERM Table.

Can someone suggest the click-event code to accomplish this?

Thanks in advance!

 

[DrJavaJoe]

Why not use an insert into statement using ado something like:

Insert into PERM Select * from Temp

then a delete statement
delete from Temp



Two strings walk into a bar. The first string says to the bartender: 'Bartender, I'll have a beer. u.5n$x5t?*&4ru!2[sACC~ErJ'. The second string says: 'Pardon my friend, he isn't NULL terminated'.

 

[Hiccup]

Thanks DrJavaJoe and here's a star for the suggestion!