Run the query to some text output file, then post process it to either an Excel file with your custom application or ... just put it in a .CSV file so Excel can open it.
I will not write your application for you, but will share how I solved a too similar application.
Bob
Hi,
I am having here a situation where I need to run a SQL query every night and generate the output into an Excel file.
I am looking for any solutions how to do this !!!
Appreciate any replys

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic