Syntaxwise, it simple:
INSERT mytable (...)
SELECT ...
FROM SERVER.db.dbo.tbl
What do you mean with "not able to insert"? You are just staring into the blue and can't figure out the syntax? Or did you trying something like above, but got an error message? Could you be more detailed?
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]