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 |
|
eVOD
Starting Member
1 Post |
 Posted - 2008-02-06 : 03:59:38
|
| Hi All,I am looking to extract all the queries from a table in sql to either excel or office.I have used SELECT Qstring FROM OUQR to list them but now i have to copy each one individually and the paste them to another document.Is there a better way to go about doing this....Thanks for the help....Cheers |
|
|
PeterNeo
Constraint Violating Yak Guru
357 Posts |
Posted - 2008-02-06 : 04:05:15
|
| Check the link describing how to import-export to excelhttp://sql-server-performance.com/Community/forums/t/12221.aspx |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-06 : 04:12:00
|
| You can use DTS to export the table data to excel. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-02-06 : 08:39:13
|
| Or if you are using SQL 2005, just change your results pane to text (ctrl-T) and then save the results as a .rpt file.You can then open this in Excel and it will have the headers. |
|
|
|
|
|
|
Extract SQL Queries