And a fourth way is to use the command line utility bcp.exe to create
a flat file with the contents of the table, then use either the same
utility or BULK INSERT to read that file in a table on the destination
server. (You must first make the table - you can use SSMS to script
the CREATE TABLE statement).
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis