Author: Atal Bihari Upadhyay Member Level: Gold Member Rank: 0 Date: 20/Nov/2004 Rating:  Points: 2 |
Hey Krishna,
I am getting the values properly withourt any jusk data and without any quote. Here is the result. ide val 1 "block1 \ block2 \ block3"
Pls check the destination (type of excel driver) you are using for export.
Regards.
|
Author: www.DotNetVJ.com Member Level: Diamond Member Rank: 0 Date: 22/Nov/2004 Rating:  Points: 2 |
Hi Atal, Could u plzz Tell me What was/is teh driver u have selected to Export is to Excel from SQL Server. Thanx -- Vijay
Thanks -- Vijaya Kadiyala http://www.DotNetVJ.com Microsoft MVP Me & My Little Techie
|
Author: Tejinder Singh Barnala Member Level: Gold Member Rank: 190 Date: 23/Dec/2008 Rating:  Points: 2 |
remover char function from your insert statement and insert data like
INSERT testcarrreturn SELECT 3, 'block1 \ ' + ' block2 \ ' + 'block3'
it will work for u
Many Thanks Tejinder Singh Barnala /*I have the simplest tastes. I am always satisfied with the best*/ SubmitYourQuery/Read New tricks
|