XML data into MDB file

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi all

I am a newbie in xml.

I have a requirement where I have a predefined XML files and I want to
add the data in these file to into Access mdb through my application

The xml structure is fixed and I hav eto implement a button which on
click submit the data to the mdb file without any further intervention
from user.

My problems are ::

1) Since xml file structure is fixed but it can have multiple nested
elements in different files, the database in MDB should be relational.
I dont know how I can achieve this. How will I maintain multiple
tables in the target database??

for example ::

one file may contain blank data like this
<images>
</images>

and another xml file may contain

<images>
<imagename>
<caption></caption>
</imagename>
<imagename>
<caption></caption>
</imagename>
</images>

2) If in future the xml file is changed I will have to change my
application also.. I want to avoid this. Is there any way in which I
can make my application handle minor changes in xml structure
automatically ?? ( for instance adding fields in database dynamically
if new field is found in xml )

can anyone help??

Regards

Preeti

.

Quantcast