Vilian,
Have you tried the code in Fraxzi's post here:
http://forums.fivetechsupport.com/viewtopic.php?f=3&t=36145&start=30#p215907
I have not tried it yet, so I don't know if it will get you what you need--at least for now.
James
aValues := oCn:QueryResult("SELECT * FROM yourtable")
oCn:Insert("newtable",,aValues)