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 |
|
JJins
Yak Posting Veteran
81 Posts |
 Posted - 2010-11-01 : 14:50:43
|
| Right now I am able to export queries by right clicking the database selecting tasks=>export data.The bigest negatives are I find myself having to delete the query tab everytime I need to export data if I want to use the same excel file.Can I somehow name the untitled tab in excel while doing the SQL data export?This would allow me to save an excel file titled "exports" and name the tab I want it to go to during the exporting process in SQL. I am finding myself having to open the excel document, making sure there is not a tab called query, if there is deleteing it, and then if I need to export another query I have to make a new excel docs.THERE HAS TO BE AN EASYER WAY.Thanks for the help!Best,GG |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-11-03 : 09:11:02
|
| If you use any front end application, you can do this from there. There is no way to delete or rename the sheet from sqlMadhivananFailing to plan is Planning to fail |
 |
|
|
JJins
Yak Posting Veteran
81 Posts |
Posted - 2010-11-03 : 10:17:25
|
| So are you saying that there is no way to direct an export to a specific prenamed tab in excel through SQL? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-11-04 : 05:39:16
|
quote:
Originally posted by JJins
So are you saying that there is no way to direct an export to a specific prenamed tab in excel through SQL?
If you want to use the existing name, try thishttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Exporting Query