>Hi,
>
>If you need to copy all records from one table on one SQL Server to a database on another SQL Server (not connected in any way to the first one), how would you do it? In the SSMS I don't see an option to export a table to Excel.
>
>TIA for any suggestions.
Data Import/Export wizard.