If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Datasources in Word 2007
Hi,
Here's my problem: I have a template which contains editable fiels. I want to fill these fiels with data from my SQL Server 2005. How can I do this? I've been searching, trying and searching some more for roughly an hour now... I want to bind each field to a query that will fill it with data from my database... Please help... |
#2
|
|||
|
|||
Datasources in Word 2007
I don't think any of the field types lets you bind to a data source in the
way I think you are looking for. If you want to fill fields with data directly from SQL Server using built-in facilities then I think your only options are a. use old-style DATABASE fields b. set your document up as a Mail merge main document with a SQL Server data source and use Mailmerge fields to include the data. however, all the data at any one time would then have to come from a single record in whatever view or table you are using as your data source. (a) used to be feasible, although probably impractical in most cases for performance reasons, because if you specified a DATABASE field that only displayed one value (i.e. one column, one row, no header) Word would show the result as inline text rather than as a single-cell table. Now, however, you cannot do this because the field result is always followed by a paragraph mark. There is a workaround for dates and numbers (see e.g. http://tips.pjmsn.me.uk/t0004.htm) For something that looks more like "binding", you have to use Word 2007 content controls. But then you can only bind (as far as I know) to the internal XML data store held as a "part" in the .docx file. In other words, you have to populate that data store separately using (say) VB.NET, C# or perhaps VBA code, but when you do, the content of the controls should reflect the data in the store more or less immediately. But you can put whatever you wantin the store, and populate it from wherever you want. -- Peter Jamieson http://tips.pjmsn.me.uk "foamy" wrote in message ... Hi, Here's my problem: I have a template which contains editable fiels. I want to fill these fiels with data from my SQL Server 2005. How can I do this? I've been searching, trying and searching some more for roughly an hour now... I want to bind each field to a query that will fill it with data from my database... Please help... |
Thread Tools | |
Display Modes | |
|
|