Downloading data from DB into a templated Word Doc

[pietb]

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 the data in the database table into a templated Word document. The purpose for this is to ensure document consistency. 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

---------------------------
Pieter Bergmans

http://www.portal2hp.com

- "Come discuss your enterprise and business class HP equipment

 

[Slippenos]

You can export data out of Access in the form of a Merge:

How to Export and Use Your Data from Access as a Word Data Source

To export and use your data from Access as a Word data source, follow these steps:

1. In Access, open your database table or query.

2. On the File menu, click Export.

3. In the Export Table or Export Query dialog box, follow these steps:

a. In the Save as type list, click Microsoft Word Merge.
b. In the File name box, type a name for the exported file.
c. In the Save in list, select the folder in which to save the file.

4. Click Save All.

Access now exports your table or query result as a tab-delimited text file.

5. Close your database, and then quit Access.