ACCESS NESTED XML FILES
-
i have a nested xml file and want this data in my database. but i read this xml file with the help of dataset dataset.readxml("file path") i got a error message The same table (recordset) cannot be the child table in two nested relations. I just want yo know how we manage this parent child relationship. :sigh:
-
i have a nested xml file and want this data in my database. but i read this xml file with the help of dataset dataset.readxml("file path") i got a error message The same table (recordset) cannot be the child table in two nested relations. I just want yo know how we manage this parent child relationship. :sigh:
This is just the way that DataSets work. Let's say you have this XML:
<Company>
<Address>
...
</Address>
</Company>
<Customer>
<Address>
...
</Address>
</Customer>This will throw an error because Address cannot be a child of both Company and Customer. You could change the table name from Address to Company_Address and Customer_Address and that will work.