DTS Export to Excel

[airedale9]

The DTS package I am using to export data to Excel works fine, apart from inserting an apostrophe (') at the beginning of each field, which then makes it difficult ordering the data as required. How do I set up the package so this doesn't happen?

 

[tlbroadbent]

Please post DTS questions in forum961. If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm