Create a linked server in your current server, where you want your data to be pulled...
Then execute the below query in your current server, whichever DB you want:
Insert into MyCurrentDB.Schema.TableName
Select * from LinkedServer.RemoteServerDB.Schema.TableName with (nolock)
It should do the trick.
You can also try the Import Export Wizard in SSMS.