About Ashvin Expertise I can handle all the queries related to XML. I can sort out problems regarding XSLT and XSL. I work using MSXML components. I can handle XML-SQl, XML-VB and XMl-ASP related queries.
Experience I have worked for 2years in this feild. I have worked in SGML and DTDs, and now working in XML and Schemas.
Expert: Ashvin Date: 3/30/2004 Subject: Export to xml in Access 2000
Question Hi Ashvin,
To export to xml format in Access 2002 is very simple, but helas I only have Access 2000.
For the moment I automatically export to txt format, then using XMLWrench I manually copy/paste and finally save it under xml format.
Maybe you know how to code that so it would be fully automatic? Many thanks in advance and have a nice day, Isabelle.
Answer Hello Isabelle,
If you want to put XML tag in the txt files you can do it by opening txt file by using ASP or VB. and then put XML tags one by one depending upon your columns.
I have never used XMLWrench So i dont know what it do, I am using XML Spy. In XML spy you have an option to convert txt file into XML. and it vey fast.
