How to automatically report an SQL query into an Excel spreadsheet in regular intervals

I am currently working on an application that is meant to be relaying realtime data on screens. I would like to know how to automatically report the resultset of a开发者_运维知识库 SQL query to a Microsoft excel sheet using SQL Server 2005.

Many thanks for your audience and anticipated help.

Cheers, Tunde

Probably the simplest way of exporting from SQL Server to Excel in TSQL with OPENROWSET. Find out more.

Then schedule the running of the TSQL using SQL Server Agent.

The best would be to write a program Or even a excel Plugin in .net that writes your query result to a csv file at certain intervals that you can open with excel.