By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,064 Members | 1,449 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,064 IT Pros & Developers. It's quick & easy.

sql server data to ms word using xml

P: n/a
ads
hi

i was given a task to display sql server data in ms word using xml. Im
currently doing research to accomplish the task. What i have in mind is to
create an xml template (or schema?) to load the sql server data first.Then
add the xml template in the ms word add-in option. Is it possible? Can anyone
point me to the right direction?

Thanks
Mar 16 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
My approach to this for the last few years (since Office XP) has been to
save a Word document formatted they way it should end up - as XML. And then
rename it to a XSL and put in iterators to populate the data from the XML
queried out of SQL Server. Contact me if you need assistance.
Chris Harrington
www.activeinterface.com

"ads" <ad*@discussions.microsoft.com> wrote in message
news:E9**********************************@microsof t.com...
hi

i was given a task to display sql server data in ms word using xml. Im
currently doing research to accomplish the task. What i have in mind is to
create an xml template (or schema?) to load the sql server data first.Then
add the xml template in the ms word add-in option. Is it possible? Can
anyone
point me to the right direction?

Thanks

Mar 17 '06 #2

P: n/a
ads
Can u elaborate your statement?hmmm it looks like interesting. What i need is
a one step configuration in ms word to accept database data then a one-click
process to display the database data in ms word. is it possible? Can you give
me links pointing to your approach?

thanks chris

"ChrisHarrington" wrote:
My approach to this for the last few years (since Office XP) has been to
save a Word document formatted they way it should end up - as XML. And then
rename it to a XSL and put in iterators to populate the data from the XML
queried out of SQL Server. Contact me if you need assistance.
Chris Harrington
www.activeinterface.com

"ads" <ad*@discussions.microsoft.com> wrote in message
news:E9**********************************@microsof t.com...
hi

i was given a task to display sql server data in ms word using xml. Im
currently doing research to accomplish the task. What i have in mind is to
create an xml template (or schema?) to load the sql server data first.Then
add the xml template in the ms word add-in option. Is it possible? Can
anyone
point me to the right direction?

Thanks


Mar 17 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.