can anyone help me.
i need to Export specific columns to excel and keep some existing fomulas in the target excel file.
for example i have 2 columns in my sql server table Number1 and Number2
in excel i have a sheet with 3 columns Number1, Number2 and a Calculation Column Number1+Number2
no idea how to, i tried openrowset but is not working fine