Problem is columns are fields and so you want to move all the records or some of the records.
You could actually do it with a query and then open the query and save it in a script using the query variable.
Otherwise you will need to open the two tables (or two tcursors) and move back and forth scanning the from table and inserting into the destination table.
Lonnie