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
Working with Difficult People | FM Radio Station
Originally Posted by rashidr
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");