Exporting MS SQL results directly to Excel
Posted on 2011-03-15
Hello, is there a way to automatically have the results from a MS SQL query get expoerted directly to Excel?
To take it one step further I have a number of scripts that users need to have run every morning or some even just every Monday and I would like to be able to set them up so they automatically fire off and save the results to an Excel spreadsheet in a specific directory with a file name. Is this possible in SQL?