Need to copy data from database1 to database2 table

Hi All,

Iam teed techinical fessibility to copy data from one database table to another except few fields.

Iam having Ztable1 with 1- 15 fields .Iam also having Ztable2 of 1- 10 fields .The difference of fields is 11-15 is missing in the table 2.so now i need to copy data of table 1-10 fields from table 1 to tables2 .The both table is having same fields from 1- 10 (fields).

Can any one guide me how to code this ?

Regards with many thanks,

Sri