Exporting data from Database to Excel based on query

E

Ella

Please I am trying to automate a dump from sql server to
an excel sheet. I know it's possible via the dts, but
since this is something I do 10 times a day, I was
wondering if it's possible to run a script in the Query
Analyser to export my query results to an excel sheet or
maybe I could create a button on a form and once I click
on it, it creates a dump of my data.

Thanks for your help in advance.

Ella
 
Top