dbTalk Databases Forums  

Data from SQl to Excel

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Data from SQl to Excel in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Connull
 
Posts: n/a

Default Data from SQl to Excel - 12-20-2004 , 02:15 AM






I am using DTS packages to export data to an Excel spreadsheet. All the data
is being inserted into the required columns but it has an ' in front. I have
changed the datatypes in Excel and when I go to the destination in my package
it sees the column as double but yet still puts the ' in front. How can I
eliminate the '.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.