PDA

View Full Version : Export to XML from Access



denise132008
07-20-2010, 12:40 PM
Hi,

I am trying to export a table from Access to an xml file. I need to change the "<headers>" and "</footers>" in the file to reflect the ones the customer needs for their import. I can use ExportXML, however, it will default to:
<?xml version="1.0" encoding="UTF-8"?>
<dataroot xmlns:od="urn:schemas-microsoft-com:officedata" generated="2010-07-15T15:35:03">

Is there any way around this in VBA? My table name is Clark_NCC. Any help would be GREATLY appreciated!!

Thanks!