I tried to search on this but was thwarted by XML being three letters long. But if there are any XML gurus out there, I need help!
My company is migrating to a platform in which the primary method of file delivery for input will be XML. We used to work exclusively with SQL and it was easy to run reports to check imported data before we applied it to the database by running ad hoc reports, etc. Now we’re faced with XML files and as of yet none of us are savvy enough with XML to work with it effectively.
Basically, we have a program that spits out XML files from incoming flat files and we need to look at the incoming data to make sure the right info is in the right column. How can we view these XML files in a table format? Is there a tool out there that would let us do multi-dimensional reports on this data so we could see what we’re about to load to the DB? I’ve had a little success in bringing the XML files into Access and validating the data in there, but there’s got to be a better way.
Mods, if this isn’t the right forum for this, I apologize in advance!