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 |
|
sharkie
Starting Member
6 Posts |
 Posted - 2008-08-27 : 09:39:20
|
| Hi,I have created a DTS procedure that takes a view from a server and transfers the data to a spreadsheet for the user. The original procedure is working fine, but the user wants this view printed off on a weekly basis and everytime I run the procedure now it just adds new rows to the existing ones. I can get round this by deleting the values in the spreadsheet before it is run again but ideally I want the details coming into the spreadsheet to replace the ones already there automatically. Does anyone know if there is a way to do this?Thanks in advance. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-27 : 10:31:08
|
| If you are using Export/Import wizard for it, then you can choose Delete row from destination table in Edit .And schedule it to run with Jobs . |
 |
|
|
sharkie
Starting Member
6 Posts |
Posted - 2008-08-27 : 11:21:37
|
| Thanks sodeep,Hadn't used the wizard before but found the option and it is wiorking fine now. |
|
|
|
|
|
|
Exporting to spreadsheet and replacing data