I need the VBA script that will export records from an ACCESS table to an XML file.
the simple "[login to view URL] acExportTable...." will not work. The XML file needs to be in a very specific format. Included in the zip file are the XSD files along with a sample ACCESS 2003 database which has the table that needs to be exported.
Success will be based on whether or not the newly created XML file is accepted by the state website when uploaded.
This should be a very simple (hopefully quick) task for someone who knows XML.