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 |
|
dmaxj
Posting Yak Master
174 Posts |
 Posted - 2009-04-12 : 12:21:32
|
| I have an MS Word document that I constantly have to update with data from an SQL Server database. I have to manually run the queries and then manually type the returned row count into the MS Word document.Is there some way that I can automate this process - like have my queries execute from the MS Word document and populate in the document?Regards |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-12 : 14:30:49
|
| you can use OPENROWSET or bcp to export results of query to word document. but still query will be executed in SSMS not in document |
 |
|
|
|
|
|
MS Word Doc and SQL Query