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)
 Export DTS to excel

Author  Topic 

apaulca
Starting Member

1 Post

Posted - 2005-06-22 : 02:12:21
hi,

I have one problem while exporting to excelfrom an SQL table. I have create a DTS package and I have to reccord in an excel workbook every month some datas and to delete the old one from the previous month. But one of the column contains more than 255 characters and when I am deleting the reccord of previous month, it will change the type of the column in the Excel sheet and I couldn't then export more than 255 characters. Does anybody know how to solve this problem. Thanks in advance

karuna
Aged Yak Warrior

582 Posts

Posted - 2005-06-23 : 06:09:09
Hi,
See if this helps
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49472

Karunakaran
___________
It's better to be loved and lost, than ever to be loved...
Go to Top of Page
   

- Advertisement -