Nevermind, I was thinking too much. It was simple, you just have to export the data to a .csv file using DTS and then edit the data for dates and then save it in Excel format.
Hope it helps others like me. 🙂
Vinu Vijayan
For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉