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,

Piet

Use bcp

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