I want to copy the data from a table say "BATCH_TEST" to another table whose name I donot know and the name can be picked from the Variable. I tried like this

mvar_name = "Table_name" where Table_Name is the table name I want to use.

To copy the structure of already existring table, I can do like
Use BATCH_TEST
copy structure to substr(mvar_name,1)

and the new table is created by the name table_name.dbf. Now I want to transfer the data also by using the variable name instead of table name

say
insert into substr(mvar_name, 1)(x,y,z)values(BATCH_TEST.x....
this gives me syntax error. Is there any other way to do so.


Thanks
Bharat