Link to home
Start Free TrialLog in
Avatar of smart2009
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
Avatar of als315
als315
Flag of Russian Federation image

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.
Avatar of smart2009
smart2009

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.
ASKER CERTIFIED SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial