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 |
|
Dancewav
Starting Member
9 Posts |
 Posted - 2002-06-19 : 09:25:28
|
| simple export of a query to an xls, but when the dts is run a second time, it appends to the spreadsheet, I want it to overwrite, what am I missing ? |
|
|
joldham
Wiseass Yak Posting Master
300 Posts |
Posted - 2002-06-19 : 09:46:51
|
| In the export wizard there should be an option to Drop and Re-Create Object. Check this box and it should delete the sheet in the Excel Workbook first and then re-create it. Additionally, if you would like to create a second sheet in the excel workbook, simply change the table name in the export portion and a second sheet will appear.Basically, think of sheets in the workbook as tables, views or SQL query results in a database.Jeremy |
 |
|
|
Dancewav
Starting Member
9 Posts |
Posted - 2002-06-19 : 10:23:55
|
| aye thats the one , cheers,wasn't using wizard so that bit eluded methank you |
|
|
|
|
|
|
quick one this surely ?