I went back and read your post again. Sorry I misunderstood your original quesion. So you have a source SQL temp table and you need to export those results to...
What I would do is create a DTS package witht he Excel source and SQL destination and define your transformation as a "ActiveXScript" and then use vb script to strip...