I having error when exporting data into excel using openrowset function.
"String or binary data would be truncated"
When using openrowset excel will not allow more than 255 characters into the columns.
Is there any Solution for this please suggest me to solve this issue.
Thanks in Advance