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 |
|
jcb267
Constraint Violating Yak Guru
291 Posts |
 Posted - 2015-01-23 : 10:57:31
|
| Hi - I have run a few queries successfully now I would like to export the results to an excel file in a specific location, can that be done? If so how??Thanks!! |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2015-01-23 : 11:07:25
|
There are three options for the result sets: Text, Grid (default) and File. There are icons in the toolbar that allow you to select which type to use. When you have File active, it will prompt you for the file and format. I usually use CSV for Excel but look at the options available and make your choice.
No amount of belief makes something a fact. -James Randi |
 |
|
|
jcb267
Constraint Violating Yak Guru
291 Posts |
Posted - 2015-01-23 : 11:23:25
|
| Yes, I have seen those, Bustaz.......I have created a reporting system in excel and sql. The input is in excel and based on the input code is generated. Through a macro in excel that code is copied and pasted into a query window in excel. The user will have to execute it and export it in excel for use by various account managers. The location could vary. I have other reporting templates in excel that will "pick up" the data from SQL and format it into a nice report for the account managers to share with the client. Can the location be specified based on the "automatically" generated code?Thanks for helping with this! |
|
|
|
|
|
|
Exporting SQL Query Results