I have DTS dumping data to Excel. It is set up to drop and re-create the
table in Excel. It all works except for one problem....when running this a
second time, the existing data in excel gets dropped, but the new data is
put into the spreadsheet below where the previous data was. So, in Excel, I
end up with 200+ blank rows then the data. When I run it again, I will have
400+ rows, then the data.
How can I fix this? I don't want it to remember where the previous data was
in Excel. I want it to always put the new data at the top of the
spreadsheet.
Also, is there a way to have it automatically create a new Excel spreadsheet
(new file) everytime I run this?
Thanks for helping,
Dan

If you use the DTS Export Wizard you will get an option to drop and
recreate the table (Excel worksheet). Look at article 319951 for details of
how to do this.

Rand
This posting is provided "as is" with no warranties and confers no rights.

Where do I find this article? Tried the knowlegdebase, no luck.

Tnx,

Hans Brouwer

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

In article <eSji15gmDHA.1676 (AT) TK2MSFTNGP09 (DOT) phx.gbl>, hansje
<hansjes (AT) anonymous (DOT) com> writes

HOW TO: Transfer Data to Excel by Using SQL Server Data Transformation
Services
http://support.microsoft.com/?kbid=319951

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Tnx for the info, Darren.

Tnx,

Hans Brouwer

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!