Solved

Export Access Query to XML with Title Number

Posted on 2011-03-01
3
209 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
  • 2
3 Comments
 
LVL 39

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 39

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

773 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