I have already this code

select * into otherdb..table from active..table

but i have existing table in otherdb and i dont want to create new table.

fro jeff_astro27

thank for the code.. ^_^

I finished my module because of this.

:P:P :):)