Export Query Results to Excel

Hi All,

I need to export query results to excel and it should be work with microsoft office as well as open office. I know how to export from grid view data to excel but I want to export query results (for example select * from employee where dept="Mechanical") to excel. Can any one help me....

Regards

Babu