E
Ed from AZ
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.
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?
Obviusly there are huge gaps in my knowledge here. Can someone point
me in a good direction to learn more about this?
Ed
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.
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?
Obviusly there are huge gaps in my knowledge here. Can someone point
me in a good direction to learn more about this?
Ed