DTS ==> Excel | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS ==> Excel

How hard is it to create an excel file and dump data (nicely formatted) into it?
tanstaafl
using the import/export wizard (i.e. DTS), it’s so easy that a chimpanzee could probably do it. Tom Pullen
DBA, Oxfam GB
LOL[<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />][<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />][<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />]<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by thomas</i><br /><br />using the import/export wizard (i.e. DTS), it’s so easy that a chimpanzee could probably do it.<br /><br />Tom Pullen<br />DBA, Oxfam GB<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
]]>