Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002

    Downloading Data from DB into a Templated Document

    Hi everyone,

    I am wondering if this is possible:

    I am thinking about building a database application. One of the tables in the application will contain information about a business activity (i.e. a policy, procedure, etc.). The business activity information stored in the database table will contain fields such as: Author Name, Department, Summary, Description, CreateDate, ReviewDate, etc. Here is what I want to do. I want to be able to download this data into a templated Word document. The purpose for this is to ensure consistency across all documents. We use MS SQL and .NET.

    Any suggestions as to whether this will work or how to make it work?

    I hope this makes sense.

    Thanks in advance,


  2. #2
    Join Date
    Oct 2003
    Use bcp

    Exec Master..xp_cmdShell 'bcp "Select * from DBName..TableName" queryout "C:\myData.doc" -c'

    Failing to plan is Planning to fail

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts