Home. 
.

transparent

transparent

transparent

Altova Mailing List Archives


Access 2007&XML: import, change, write back to XML?

From: Ed from AZ <prof_ofwhat@-----.--->
To: NULL
Date: 4/1/2009 8:53:00 AM
We have a report generating program that writes everything into an
XML file.  I'm vaguely familiar with XML - I know it consists of open
and close tags with information in between.  Each screen of the
report
program generates its own set of tags.  There doesn't seem to be an
identifiable schema attached to these files.  (And while I think I
understand that the "schema" is in part how the tags are applied, I
obviously don't understand very much!)

Often, we need to merge items between reports, or cut out certain
items and make them a separate report.  I've played with various ways
of doing this using the XML file, vice pulling up the report inside
the program and going through screen by screen, line by line, and
editing.  I managed to get a macro in Word by opening the file as
text, but it's clumsy.  Excel imports the whole thing into a huge
spreadsheet that's hard to make sense of.  Access, though, imports
the report XML and separates each section into its own table.  That
would seem to be wonderful for moving only certain records from one
report into another.

(Note:  I'm sure there are programs out there that would handle
all this beautifully, but I am not able to use them for reasons too
complicated to go into here.  I'm stuck doing this with what I've
got.)

The wall I run into is how to write it back out into an XML file with
the appropriate tags?  Does Access store these tags in the table
somewhere, and new information will inherit them?  Since there
doesn't seem to be a recognizable schema connected with these
files, can Access create one based on the imported document?

Obviously there are huge gaps in my knowledge here.  Can someone
point me in a good direction to learn more about this? Or a better
way?

Thanks!!
Ed


transparent
Print
Mail
Like It
Disclaimer
.

These Archives are provided for informational purposes only and have been generated directly from the Altova mailing list archive system and are comprised of the lists set forth on www.altova.com/list/index.html. Therefore, Altova does not warrant or guarantee the accuracy, reliability, completeness, usefulness, non-infringement of intellectual property rights, or quality of any content on the Altova Mailing List Archive(s), regardless of who originates that content. You expressly understand and agree that you bear all risks associated with using or relying on that content. Altova will not be liable or responsible in any way for any content posted including, but not limited to, any errors or omissions in content, or for any losses or damage of any kind incurred as a result of the use of or reliance on any content. This disclaimer and limitation on liability is in addition to the disclaimers and limitations contained in the Website Terms of Use and elsewhere on the site.

.
.

transparent

transparent