如何在sql中将数据从一个表导入到另一个表

I have two database there is two table both databse how to import data from database table to another database table in sql2008 standard edition. I have tried to export/import function but no luck . would you Please help me ?I have two database there is two table both dat