Send Selected Data from sql server 2005 to excel

[MickDub]

Hi, All

Wondering if someone one could help me on how to
after i have written my select statement how do i send the records returned to excel

So if i have "select f_Name,L_Name from table where L_name="Murphy" from Details", what do i need to do next to export the result to excel

Cheers,

Mick

 

[Zathras]

Easiest way is to do this from the Excel side.

See the Excel menu for Data / Import External Data / New Database Query... and follow the wizard.

If you still need help, you should post in forum68 (Microsoft:Office).