Export sql output to word Document

  • Does anyone have an answer to show, how a sql output can be exported to a word document with a std template? Any suggestion or ideas would be greatly appreciated. TIA

  • AFAIK you cannot do it from an sql batch. I probably would write a vba script that opens a word document and a db connection, executes the query and writes the resultset into the word document.

    But that is OT.

    Another way is to implement a SSIS data flow and write a custom destination component that write to a word document much like the way in the above mentioned solution.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply