export to excel

[Spyrios]

I can use DTS to export to Excel, but it looks ugly as all get out. In Access it will export it giving column names (greyed out to distinguish them) and spaced correctly. In DTS it's just thrown it in there. How do I get DTS to format the excel file the right way?

 

[fluteplr]

Basically you don't. DTS is a data pump, pure and simple, it is designed to get data from one place to another as efficiently as possible. If you want pretty I would suggest using another product.

 

[JohnDTampaBay]

You could write a VB script task to run after the data pump to open the Excel document just created and format it as desired. I am not a VB buff, but I have seen it done. Good luck!

--Angel
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)