I need to export to xml 1 record at a time

[Timothy via AccessMonster.com]

I have a table with 500 records, and I need to export each record
individually to xml. I am using Access 2003 and it exports the entire file
fine, but for whatever reason, the end user is requesting it one record at a
time. I have seen a few vba procedures that will seemingly do something like
this, but I have been unsuccessful in making them work in my application.
Any direction would be greatly appreciated.

Tim

 

[John Nurick]

Hi Timothy,

See my answer to a similar question today in the thread "How to export
XML file per record?" in the newsgroup
microsoft.public.access.gettingstarted.

 

[harrell.geron]

I have a table with 500 records, and I need to export each record
individually to xml. I am using Access 2003 and it exports the entire file
fine, but for whatever reason, the end user is requesting it one record at a
time. I have seen a few vba procedures that will seemingly do something like
this, but I have been unsuccessful in making them work in my application.
Any direction would be greatly appreciated.

Tim

I tried for a long time to get XML into Access, I was finally did it.
You may need
the complete structure, (ie. what items are on the same branch of the
XML tree) like I did,
If so, please let me know.

 

[Timothy via AccessMonster.com]

That worked perfectly. Thanks so much!

Tim

I have a table with 500 records, and I need to export each record
individually to xml. I am using Access 2003 and it exports the entire file

[quoted text clipped - 7 lines]
I tried for a long time to get XML into Access, I was finally did it.
You may need
the complete structure, (ie. what items are on the same branch of the
XML tree) like I did,
If so, please let me know.

 

[harrell.geron]

I have written VB code that quickly reads XML and builds first one
table that contains the XML data with the levels and relationship of
nodes and data, then second builds related tables with the primary
keys and foregin keys. The "Relationship Layout" beautifully shows
the data relationships. Recursing the XLM into the first XLM
datatable was a pain in that the
unknown XML data was not predictable. But through trial and error I
found ways to read 100,000 lines of XML, sorted out
into related tables in a couple of minutes. If the "end user" wants
the data one record at a time this could be accomplished quite
easily. Pls send me your XML and I will test it, and show you how you
can do it also. Attached it to an email to (e-mail address removed).