Solved

Export Access Query to XML with Title Number

Posted on 2011-03-01
3
212 Views
Last Modified: 2012-05-11
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
Comment
Question by:smart2009
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 40

Expert Comment

by:als315
ID: 35014630
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
 

Author Comment

by:smart2009
ID: 35019699
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
 
LVL 40

Accepted Solution

by:
als315 earned 500 total points
ID: 35024503
You can use this example:
http://msdn.microsoft.com/en-us/library/bb258193(v=office.12).aspx
for additional structure elements
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question