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.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | bbasirYak 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. |  |  
                                |  |  |  |