JoanneJames
Registered User.
- Local time
- Today, 09:09
- Joined
- Feb 19, 2008
- Messages
- 59
I am trying to create an xml file from a query. I ran the query then selected Export - xml file (using Access 2010). The query generates 637 recs having 9 columns. While it takes about a minute to process, I am only getting the following in my xml file that gets created:
<?xml version="1.0" encoding="UTF-8" ?>
<dataroot xmlnsd="urn:schemas-microsoft-comfficedata" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="qryOPPCPtAllergyInfoSeg.xsd" generated="2011-02-15T12:40:47" />
The xsd file gets generated just fine.
I have spent hours trying to find something on the internet about this and get nothing. I WAS able to export results into Excel and create xml file from there, but prefer to generate directly from Access. Anyone have any ideas??
<?xml version="1.0" encoding="UTF-8" ?>
<dataroot xmlnsd="urn:schemas-microsoft-comfficedata" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="qryOPPCPtAllergyInfoSeg.xsd" generated="2011-02-15T12:40:47" />
The xsd file gets generated just fine.
I have spent hours trying to find something on the internet about this and get nothing. I WAS able to export results into Excel and create xml file from there, but prefer to generate directly from Access. Anyone have any ideas??