I'm trying to add data from a bunch of xml files (approx 1600!) into a more readable and workable excel file, or ms access file, or actually to any kind of format that would be in a "table" format rather than in xml. It's a parts catalog, so that's why I want to have the data in a table format instead for future upload into our legacy system. The solution must loop all the files in the directory to read in all the data from the files in there (all xml files).
The key data I'm looking for in these files are the values for:
found under the "pnrmfr" tag or whatever it's called.
Pls see if either one of you guys are able to sort this out, would be super!
Thanks / Peder