Click to See Complete Forum and Search --> : Import a xml-file into Ms Access


digital_storm
11-19-2003, 09:28 AM
Hello!

I want to import a xml-file into a ms access database it works fine beside....
I want to have all information in on table but when I import my xml-file i get two tables one for "element" and one for "que2". Why does this occur?
My xml-file looks like:
----------------------
<element>
<que1></que1>
<que2>
<que21></que21>
<que22></que22>
</que2>
</element>
<element>
<que1></que1>
<que2>
<que21></que21>
<que22></que22>
</que2>
</element>
---------------------------------------

I Can I do something so all data will be shown in one table?

Regards // digital_storm

TheBearMay
11-19-2003, 09:41 AM
Just guessing, but it appears that the second table is constructed because Access sees sub-elements nested under que2. I'll try a few things and get back to you on how to correct.