Creating Linked Server will solve your problem......
Can you please post what exact error you are getting while inserting?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/