I basically want to export the output of the above query into an excel spreadsheet.

For me , Bcp is not working.

OPENROWSET did work , which actually transferred (exported) the...

Is there any option other than OPENROWSET to export the result set into excel spreadsheet ?

Thanks

Hi Lowell,

First of all , Thanks for prompt reply.

I do not get any error. In fact i get the output mentioned below.

output

usage: bcp {dbtable | query} {in | out |...