Write query results to Excel using a linked server and T-SQL

(Eli Leiba) SQL Server has several tools for exporting and importing data. The simple utilities like the T-SQL statement BULK INSERT or the BCP utility does the data transfer by using flat text files. In order to deal with any other type of file to be exported or imported we must construct a DTS pac

Read More - Register for Free Membership