Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

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
0
smart2009
Asked:
smart2009
  • 2
1 Solution
 
als315Commented:
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.
0
 
smart2009Author Commented:
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.
0
 
als315Commented:
You can use this example:
http://msdn.microsoft.com/en-us/library/bb258193(v=office.12).aspx
for additional structure elements
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now