Welcome to Dream.In.Code
Become an Expert!

Join 149,493 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,341 people online right now. Registration is fast and FREE... Join Now!




Creating xml from two tables in access 2003

 
Reply to this topicStart new topic

Creating xml from two tables in access 2003, problem with the xml

ross_petersen
17 Mar, 2007 - 08:31 PM
Post #1

D.I.C Head
**

Joined: 6 Aug, 2005
Posts: 58



Thanked: 1 times
My Contributions
Hi folks

I have an access db that has two tables with a one to many relationship that I want to export as an xml file.

I have created a query that joins the two tables together and have successfully exported that, but the data related to T1 of course gets
repeated.

Really what I want to get is the xml data related to T1 only to be lsited once (for each record in T1) then the related records in T2 to be listed as they relate to T1.

Is there any way this can be achieved?

Kind regards

Ross Petersen
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 1/7/09 05:48PM

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month