|
Subject:
|
Auto populate a word document with Visual studio 2
|
|
Posted By:
|
kenn_rosie
|
Post Date:
|
1/27/2006 3:50:56 AM
|
Auto populate a word document with Visual studio 2003
I am using Visual studio 2003
MSSQL Server 2003
I would like to know if there are any articles out there
that shows
1. how to auto populate a word document with db fields
such as Last name, first name, phone
2. How to view the document on the web page
3. Print the document from the web page
|
|
Reply By:
|
jazzcatone
|
Reply Date:
|
1/29/2006 2:45:40 AM
|
Your best bet I think is to just to use Data Transformation Services in SQL Server. Go to the table you want to take data from, right click on the table, go to all tasks, then go to Export Data. DTS will pop up and it kind of walks you through a process where it will ask you where you want to take data from (a Data Source) and where you want to put the data ( a data destination) Choose text file fom the drop down and then it will ask you to browse to the file (your word file) you want to put your data into. Browse and click your file to which you want to export the data. - Jason
|
