Question Cant import xml file data into access table

[chango]

Using the import wizard to import an xml file into access is working fine with no errors , although i have selected to import table structure and data but access imports the table structure without data.

however, when i import the same xml file using excel, the excel sheet displays complete data.

Have any one experienced this issue before and what is the work around please. And why access cant import the xml file data?

Thank you all.

 

[gemma-the-husky]

the thing is, it doesnt import into Excel in a format that would be particularly useful for Access

A lot of data in the XML file probably wont need importing to your dbs anyway

I find the only way to manage XML files is to write code that "walks" the xml tree, and processes the tree manaually.

Not sure if anybody else can use the automation functions

 

[TechNat]

Do you know if the xml file is element-centric or attribute centric?