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 column conversion to Excel

Author  Topic  kkbaker Starting Member 1 Post Posted - 2008-04-10 : 11:41:31 Help, below is a condensed version of my issue. select *, cast(count(*) as Int) as Total from test This is a datapump task in my dts package that exports to excel 8.0. Whether I do this via the wizard or manually the results are the same the total column is text in excel. On that note, the data is actually store in the table as an INT but I am casting to help excel whether I cast it or not the results are the same. I have also formatted the column in excel to make certain it is a number and to no avail, still text. What do I need to do in the dts package to make sure this exports into excel as a value (number)? Thank you, KKBAKER Thought I should add, I am not allowed to openrowset, it's locked down by the admins. I am using DTS from SQL 2000 on a SQL 2005 db.