Move data from one axtable to another ax table

i just want to move data from one one ax2009 table to another table(copy of tat table)

for eg, i created a duplicate of vendtable and tried to move the data from vend table and copy of vendtable( renamed as arun_vendtable), i changed some of enum type also eg instead of vendtable enum i created arun_enum.

from backend i did,i used query to move the data from one table to another, but the enum fileds are not moved properly,

it takes the default values, for eg in enum 0,1,2 but it inserts the default value 0

anyone did before like this???

suggest me some idea

thanx in advance.

Can you show us what and how you actually do?