I am looking for query tool which exports ms sqlserver data to excel. Already searched google but not satisfied with the result. Is there any free tool available. which execute sql query and display output in excel
You can do it with PHP (search php output to excel) and if you have access to coldfusion it can do it too.
Both use a variation of the header/content tags to point output to excel.
header("Content-Disposition: attachment; filename=\"$filename\""); header("Content-Type: application/vnd.ms-excel");