smart2009
asked on
Export Access Query to XML with Title Number
Hello Everyone,
I have a couple Access Queries that I would like to export to xml. Does anyone know how to assign a macro to do this so I don't have to do it manually? Also the xml file is used in Flash and I am using title reference to call the specific record. Like below
<BIG_DOG TITLE="2">
<store>82 - Salmon Creek</store>
<gp>1753.61</gp>
</BIG_DOG>
<BIG_DOG TITLE="3">
<store>92 - Kitsap</store>
<gp>1571.56</gp>
</BIG_DOG>
Can someone explain how I could do this with an export? Or is this a custom module?
Thanks again!
Jester
I have a couple Access Queries that I would like to export to xml. Does anyone know how to assign a macro to do this so I don't have to do it manually? Also the xml file is used in Flash and I am using title reference to call the specific record. Like below
<BIG_DOG TITLE="2">
<store>82 - Salmon Creek</store>
<gp>1753.61</gp>
</BIG_DOG>
<BIG_DOG TITLE="3">
<store>92 - Kitsap</store>
<gp>1571.56</gp>
</BIG_DOG>
Can someone explain how I could do this with an export? Or is this a custom module?
Thanks again!
Jester
Access have standard export to xml. Have you tried it? If result is good enough, you can easily automate this process with code or with macro.
ASKER
I have used it and it works pretty well except I am not sure how to add the TITLE to the main tag like
<BIG_DOG TITLE="2">
The 2 would be the record number.
<BIG_DOG TITLE="2">
The 2 would be the record number.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.