pitaman
asked on
How to add data from multiple xml files into a excel sheet (2003) or ms access (2003) file?
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:
- "pnr"
- "mfr"
- "kwd"
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
11-13-01-01.xml 11-16-01-01.xml
The key data I'm looking for in these files are the values for:
- "pnr"
- "mfr"
- "kwd"
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
11-13-01-01.xml 11-16-01-01.xml
I've never used the program, but would something like http://www.xml-converter.com/ work for you? Looks like it has an option to output to Excel.
Also found a free converter at http://www.cobynsoft.com/products/freeware/cobynsofts-data-viewer/ Again, I haven't used the program, but I figure free is better, if it works for you.
ASKER
Thanks quizwedge for your quick reply. But, I simply cannot get either of these two softwares to produce a listing with the values for pnr, kwd and mfr on the same line in, for example, an excel sheet. Any more suggestion of programs (free or not free) is highly appriciated!
Can't figure out how to do it with the free one, but the paid one should work like this
1. Select the file
2. Under tools, choose Global Tables
3. Click on pnrmfr. That should be what you want.
Then, to export it,
1. Click on file -> export tables
2. Uncheck all but pnrmfr
3. Choose your file type
4. Click convert
I think that's what you're looking for. Let me know if I missed something.
1. Select the file
2. Under tools, choose Global Tables
3. Click on pnrmfr. That should be what you want.
Then, to export it,
1. Click on file -> export tables
2. Uncheck all but pnrmfr
3. Choose your file type
4. Click convert
I think that's what you're looking for. Let me know if I missed something.
ASKER
Hi again,
it works just fine when working with one file at a time, I get the columns and rows that I want with great ease. But it seems like the batch processing of files doesn't have that feature to pick only a few of the available informations, with that function I get the entire information from each file unfortunatelly. Maybe the full version has some other features in it..
it works just fine when working with one file at a time, I get the columns and rows that I want with great ease. But it seems like the batch processing of files doesn't have that feature to pick only a few of the available informations, with that function I get the entire information from each file unfortunatelly. Maybe the full version has some other features in it..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great replies.