query result

[b_s_meena]

sir,
I have run a query in the SQL server (select) and got the results now i want to save this result in the excel shhet(file) how can i do this ?
plz. help me

[kalyansantosh]

ok
if u reteive the data frm the table it is displaying like table
u do ctrl A+open the excel sheet in ctrl+V
otherwise by using data transfer we can do
other wise i iwll tell the process briefly

[b_s_meena]

sir the file data.xls is blank plz. send the snap shots again
thanks

[kalyansantosh]

ok
i will sent after

im in work
otherwisse mail me my id

[b_s_meena]

sir,
i am waiting for your reply thanks