I am trying to get all the records from one table into another table but these tables (which are identical) are on separate servers.
Any help would be appreciated.
If your goal is just a one time transfer, the quickest method would be to use SQL Server Import and Export Wizard (Right click on the database - Tasks - Export Data)
And here is SQL Server Management Studio Express (64-bit) if you don't have one already.
Assuming you meant
You can use OPENROWSET
You may rule it out though because of whatever constraint you have that's stopping you from using a linked server.
If that's the case you'll need to use an ETL tool like SSIS or write a process in a client tool that does it without