import data from xml into msword 2007

I have developed an app that queries a database then creates n xml file hat contains the data retrieved. I am looking for a way to import this data into a word document. I would like to be able to control where different elements of data  are placed in the doc. any ideas?

thx
stephi01Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

YiogiCommented:
Yes use mail merge and since you are using word 2007 and XML, you will be a happy man. Word 2007 can have an external xml source inside the actual word document so any time you want to change the source you just change the xml document. All word 2007 files are actually zip files. Simply rename it and open it with a zip editor. Navigate to the customXml folder and there you can have your custom xml files.

You can easily open and edit word files as packages with Microsoft DotNet framework 3 programmatically and change the xml files as you wish. Or you can do this manually if by renaming the file to .zip and then to .docx. There are plenty of sources online a very good side being www.openxmldeveloper.org since word 2007 is actually open xml.

If you need more help or some code let me know I'll gladly help you more.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
stephi01Author Commented:
Thanks for the resources Yiogi! I learned a lot about openxml and found the solution I need!
0
stephi01Author Commented:
Thanks for the info! I found exactly what i needed!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.