Excel + XSD --> non-redundant DataSet

Hello,

I whish to do the following:

1. I have an Excel work*** with redundant data: a table coupling
customer data with their associated bought products. For each product
bought, their exists a row with customer and product information. So,
this is in effect a very bad data source

2. I also have an XML schema describing what the data should look like.
In effect it gives some sort of relational structure to the data.

Now I would like to combine those two together and create a relational
DataSet from the XML scheme (this works) and fill it with the data
provided by the Excel ***.

The only problem is dat I should do this without knowing anything about
the structure of the Excel file, nor about the structure of the XML
scheme.

I figured if there exists a one to one mapping of column names in the
Excel work*** and the XML elements this could be done, but this is of
course not that simple as the relational DataSet inferred by the XML
scheme contains more metadata than the data in the Excel work***.

Does anyone have any suggestions about handling this problem ?

In fact, this comes down to mapping the result from a JOIN operation to
the original relational structure without knowing anything in advance
....


Your help is much appreciated,

Lennert.

.