473,326 Members | 2,102 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

sql server data to ms word using xml

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
2 2295
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Diane Yocom | last post by:
I have an ASP intranet application that is required to produce Word documents merged with data from a database. I originally looked at automating Word's mail merge capabilities, but nixed that...
3
by: Brian Kwan | last post by:
Project Description: Develop a web application to help manage sale operations. There is a function that to generate a report using data in database, which is a Word document on server and let user...
2
by: Manish Naik | last post by:
Hi, Using ASP.Net, I want to store and retrive documents (Word, excel, etc) from SQL Server 2000 database. I have tried image type data field, but could not succed. Can any one help me please. ...
0
by: savvy | last post by:
I am developing a Recruitment Agency Website I am using MS SQL Server in which I have a table called CV_Details which stores all the details of different Job Seekers. I have stored all the Word...
4
by: Kash | last post by:
Hi everybody: I've developed a web application running on a 2003 server not on the web but on extranet environment of a small Firm (less than 10 users). I've taken benefit of Office Primary...
9
by: sweetpotatop | last post by:
Hello, I wonder how I can populate the fields of a Word template in asp.net. Please note that data will be coming from a DB on the server. Thanks in advance.
29
by: Jan | last post by:
Hi: I have an Access database that's been running (in one form or another) for a couple of different clients for a few years. Now a new client has requested that it be implemented with a SQL...
20
MMcCarthy
by: MMcCarthy | last post by:
This problem was proposed to me but not really my area of expertise so I thought I would open it up to the forum to see if anyone had any bright ideas. The problem is generating Microsoft Word...
1
by: amit saini | last post by:
Hi I have using back end sql server 2000, fornt end Visual Basic and For reporting using Ms-Word 2000. I have face a problem . In sql server i have using Image type data type and stored a image in...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.