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 export into Excel

Author  Topic  steffi Starting Member 3 Posts Posted - 2005-03-04 : 05:59:35 I am trying to transform a csv file into Excel. The csv file has no column header row. But DTS generates a dummy header row in the first row of the Excel sheet like this: col001 col002 col003..... What can I do to this?