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.
Microsoft ApplicationsMicrosoft Access
Last Comment
tbsgadi
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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