Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-25 : 10:41:44
|
| Ben writes "HII'm using Sql Server 2000, and i used a dts to export my data from the sql server to excel, i wanted to know if i have a way to truncate the excel table each time i run the dts, so i'll get the new data in my excel sheet each time the job runs" |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-08-25 : 12:55:21
|
Just a suggestionU may have Excel Connection, if not have a connection to that file (Get from DTS Design)Get a "Execute SQL Task" in DTS designand use the SQL statement Drop table [Sheet1$]Something, which I noticed here is, after deleting, the Excel file becomes larger than that with data (atleast in my case)  Srinika |
 |
|
|
|
|
|
Exporting to excel