Click here to Skip to main content
14,090,506 members
Rate this:
 
Please Sign up or sign in to vote.
Hi Guys

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


Piramanayagam.U
Posted
Updated 7-Nov-11 1:34am
v2
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

This[^] may help you.
   
Comments
   
Found, a 5.
--SA
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

   
Comments
   
Found, a 5.
--SA

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Cookies | Terms of Service
Web04 | 2.8.190518.1 | Last Updated 7 Nov 2011
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100