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 |
|
skchaman
Starting Member
6 Posts |
 Posted - 2004-11-04 : 00:19:41
|
| Hi,how can I send the sql query analyser data in excel format and execute the macros already saved with the file.Or is there any way to generate graph using stored procedure. Thanks |
|
|
hgorijal
Constraint Violating Yak Guru
277 Posts |
Posted - 2004-11-04 : 01:40:42
|
| If you are onlu looking for QA results to be copied into excel, you can view the results in GRID format and copy paste it into the Xel file. If it is the output of a query or table that you want to export to Xel, Export the data to that excel file using DTS.ofcourse, either way, you will not be getting the column names; so you need to have them in the Xel file prior to loading data.can't generate a graph using SP.Hemanth GorijalaExchange a Dollar, we still have ONE each._______Exchange an Idea, we both have TWO each. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-11-04 : 06:25:08
|
| You can populate the spreadsheet using dts using a data transformation task or t-sql using a jet datasource.You can execute the macros using vbscript in dts or the sp_oa... sps in t-sql.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-04 : 14:36:40
|
| You could also ahve the Excel spreadhseet connect to the database itself, get the data it wants, and then run the macroData : Get External data : ...Kristen |
|
|
|
|
|
|
Output in Excel format or Generating Graph