>Jim thanks for your reply, but i am asking about changing case. in my table variables name is in lowercase. butconverting inot excel i want uppercase.
Your question is not entirely clear. Do you want to specify your own headers for Excel columns or you want content of the column to be in the upper case, but still have lower in the table you're creating by select-SQL for other purposes?
If it's not broken, fix it until it is.
My Blog