<div>
tristan69,<br />
<br />
Also have a look at <a href="http://download.cnet.com/MS-Access-to-XML-Convert-Software/3000-10254_4-127561.html" rel="ugc">http://download.cnet.com/MS-Access-to-XML-Convert-Software/3000-10254_4-127561.html</a><br />
Gary
</div>


<div>
I look at the ado object and the xml it generated but that will not work. instead I have take a look at DOM and I have had some of the success I have been looking for but its new to me and I am green. So if any of you guys have some tip about using DOM to generate xml let me know.<br />
<br />

</div>


<div>
Have a look at these<br />
<a href="http://www.thescarms.com/xml/DOMTutorial.aspx" rel="ugc">http://www.thescarms.com/xml/DOMTutorial.aspx</a><br />
<a href="http://msdn.microsoft.com/en-us/library/ms766564(VS.85).aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms766564(VS.85).aspx</a>
</div>


<div>
The first link I sent is a working solution to the askers question.<br />
Afterwards when the asker asked for some help with DOM I also sent useful links on the subject.
</div>


<div>
<div class="content wysiwyg-content">
Hi Guys,<br />
I need to export a recordset to a XML file using VBA and Access. Now I know that Access 2003 and higher has this feature built-in however I have Access 2000, also I would prefer to use VBA.Since in addition to the recordset other information have to be added to the XML file.
</div>
</div>


Hi Guys,
I need to export a recordset to a XML file using VBA and Access. Now I know that Access 2003 and higher has this feature built-in however I have Access 2000, also I would prefer to use VBA.Since in addition to the recordset other information have to be added to the XML file.

tristan69,

Also have a look at http://download.cnet.com/MS-Access-to-XML-Convert-Software/3000-10254_4-127561.html
Gary

I look at the ado object and the xml it generated but that will not work. instead I have take a look at DOM and I have had some of the success I have been looking for but its new to me and I am green. So if any of you guys have some tip about using DOM to generate xml let me know.



Have a look at these
http://www.thescarms.com/xml/DOMTutorial.aspx
http://msdn.microsoft.com/en-us/library/ms766564(VS.85).aspx

The first link I sent is a working solution to the askers question.
Afterwards when the asker asked for some help with DOM I also sent useful links on the subject.

Generate XML File using VBA

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.