Welcome to VBForums

There are 2 main steps for this process - getting the data from Access, and putting it into an XML file.

For getting the data from Access, see the articles in the "Classic VB: ADO" section of our Database Development FAQs/Tutorials (at the top of the Database Development forum)

For putting it into an XML file, I suspect there will be examples in our Codebank - VB6 forum. If not, check out the "Files" section of our Classic VB FAQs (in the FAQ forum), but that way you will need to write code to add the XML tags to the text as apt.


Give it a go, and ask us for specific help if you get stuck