Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS VARCHAR WITH SINGLE QUOTES COMES BLANK

Author  Topic 

bbasir
Yak Posting Veteran

76 Posts

Posted - 2008-04-09 : 19:43:44
When I export use vbscript to create an excel file inside dts, my single quote data doesnot export to excel it is blank... when it is exported to excel..

all other varchar data is correctly loaded....

only the varchar data that has single quotes inside them doesnotn get exported to an excel file.

i am using vbscript and excel objects inside teh code.
   

- Advertisement -