TSQL Query to Excel Table

[thisisboni]

Hi:

Is there a way I can get the result set of a query into an excel table ?

Thanks

 

[markros]

Yes, just right click on the result and chose Save to Option. Alternatively, if it's not too big result set, you can right click, select all and then use copy (with headers) and then just paste into Excel

PluralSight Learning Library

 

[thisisboni]

Thanks but I'm looking for an automated solution also it needs to be an excel table and not just a worksheet

\