Dear all,

I am not sure if I am at the right place for my question.
I have a SQL server table, I have to set the schedule (every morning at 8:00
a.m.) that the data from this table is automatically transferred to a
specified Excel file. I know that there is an "Excel Connection" in DTS
package which allows me to do this task, but I have to erase the existing
data in Excel first. Can I still use this method? If not, any other
suggestion?
Please advise. Thanks in advance.

Ivan

Have you seen this article

http://support.microsoft.com/default...;en-us;Q319951

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Ivan" <Ivan (AT) discussions (DOT) microsoft.com> wrote