Import XML to Access

[VirginiaJenkins]

Hii..


Im working on a personal project where I need to import an XML(several) file to Access. I play a game called War-hammer 40k that has about 14 different armies, each army with 70+ units, each unit with different stats. There is an open source platform with all of the data in XML with .cat extensions. When attempting to import the data, it creates useless tables, with almost no data. I fell like this should be a simple import, but with very little knowledge of VBA or XML, I'm stuck. I'll include a link below for the data file. If someone is willing/able to assist, I'd be forever in your debt (or would be willing to compensate a little for your time and effort). Thank you for your time and effort regarding this!



Please help.


I didn't find the right solution from the Internet.


References:-
http://www.accessforums.net/showthread.php?t=70665
Cryptocurrency Wallet Marketing


Thanks!

 

[mole999]

Please read the rules you agreed to when joining. No one is allowed to offer payment (or request payment), unless you contract from MrExcel etc

 

[james_lankford]

https://stackoverflow.com/questions/28510534/issues-with-importing-xml-data-into-access

MS Access can only import xml that is laid out by elements
like this

{profileType}
  {id}e6d5-85c5-7b01-a3c4{/id}
{/profileType}

not by attributes
like this

{profileType id="e6d5-85c5-7b01-a3c4"}{/profileType}

https://support.microsoft.com/en-ie/help/285329/you-cannot-import-attribute-centric-xml-in-access

maybe Micron will put in the time for you, but it jsut seems like too much work for me

and this forum doesn't like my greater than less than signs so I changed them to curly brackets

 

[mole999]

https://stackoverflow.com/questions/28510534/issues-with-importing-xml-data-into-access

MS Access can only import xml that is laid out by elements
like this

{profileType}
  {id}e6d5-85c5-7b01-a3c4{/id}
{/profileType}

not by attributes
like this

{profileType id="e6d5-85c5-7b01-a3c4"}{/profileType}

https://support.microsoft.com/en-ie/help/285329/you-cannot-import-attribute-centric-xml-in-access

maybe Micron will put in the time for you, but it jsut seems like too much work for me

and this forum doesn't like my greater than less than signs so I changed them to curly brackets

< needs a space after it as its treated as html formatting and can disappear