Hi , i need to convert Ms Access table to xml file, any body plz help me by providing some VB source code for that (in need VB source not VB.net)
Printable View
Hi , i need to convert Ms Access table to xml file, any body plz help me by providing some VB source code for that (in need VB source not VB.net)
Welcome to VBForums :wave:
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
It only takes a few lines of code if you have Access available to you or will be on your target system.
How do I export data from Access to an XML file?
:)