hi,

thanks 4r reply.

i want to know , how can i export the sql server query result to multiple excel sheets.

through sql jobs. i can do thid with openrowset on single excel sheet but unable to do on multiple excel sheets (date wise.).

thanks.