blog.davidyardy.com — Over the years there have been a number of methods to move SQL data into Microsoft Excel. Using Automation you can call methods and properties that are specific to excel which gives you the greatest flexibility for specifying the location of your data in the workbook. The following are two recent approaches to export Sql Server table row data to an excel workbook.
1.) Using Automation you can use transfer data cell by cell
2.) Transfer data in an array to a range of cells (much faster)
original link