tristan69
asked on
Generate XML File using VBA
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
Afterwards when the asker asked for some help with DOM I also sent useful links on the subject.
Also have a look at http://download.cnet.com/MS-Access-to-XML-Convert-Software/3000-10254_4-127561.html
Gary