Hi , I have to select a huge amount of data from a big table to another server in another domain. There is no excel in the server. Can any body please,suggest the best possible way to do that. Thanks in advance for your help
Use either BCP or SSIS to copy the data to a flat table, copy the file over the network and load it on the other server.
You don't need the Excel software just to use the Excel file format. SQL Server will gladly create an XLS file for a data dump, or read data from an existing XLS file.
