XML from existing XSD

[mchapman13]

I am VERY new to XML and I am very confussed. Hoping someone could shead some light on my problems.

IS this even do-able and if so what am i doing wrong

WHAT CURRENTLY EXISTS:

I have an existing XSD file that has all my XML tags that currently exist in my DB, it has the correct structrure for recursive tags (ex: if a person can have more then one address the adress tags are set to UNBOUND, the whole 9 yards)

The PROBLEM:
Some of my clients are unable to provide me with an XML file (in a timely fashion) so what I need to be able to do is take ANY flat file (sometimes multiple flat files, such as EXCEL files) and map each column within these files to my existing XSD tags then convert the XLS to XML.
I have been able to do this with one flat file (not multiple which isnt a big deal except) I am unable to get a recurrion from that flat file. IE when a person has more then one address how can i get it add a second input.

I simply need a quick way of converting any of my clients existing data files into an xml file that will import into my DB based on the XSD schema I have, and I need it to be able to account for multiple instances in some tags.


Full on example:
How my XML should be formated
<ROOT>
<KEY>
other demographic elements
</KEY>
<ADDRESS>
<ADD> one row record on my data file can have multiple ADD's within the 1 ADDRESS tag
</ADD>
</ADDRESS>
</ROOT>

Sample of XLS file headings:
Unique_ID FName LName Address1 City1 State1 Address2 City2 State2

Withing the one ROOT element (row existing for 1 individual on the data file), how do I map address2 ... to exist as a second ADD in the 1 ADDRESS tag for with out creating a SECOND ROOT tag for the address.

HELP PLEASE.

Thanks

[jkmyoung]

Could you show us an example of a 2nd row after the first row? Where does one set of data end and the next begin?

[mchapman13]

The xls will have something like

Sample data on the excel sheet

123 john doe anystreet anycity anystate anystreet2 anycity2 anystate2
234 jane smith mystreet mycity mystate
345 sally mae herstreet hercity herstate herstreet2 hercity2 herstate2

NEEDED OUTCOME IN XML

<ROOT>
<KEY>
<UNID>123</UNID>
<FName>john</FName>
<LName>doe</LName>
</KEY>
<ADDRESS>
<ADD>
<STREET>anystre et</STREET>
<CITY>anycity </CITY>
<STATE>anystate </STATE>
</ADD>
<ADD>
<STREET>anystre et2</STREET>
<CITY>anycity 2</CITY>
<STATE>anystate 2</STATE>
</ADD>
</ADRESS>
</ROOT>
<ROOT>
<KEY>
<UNID>234</UNID>
<FName>jane</FName>
<LName>smith</LName>
</KEY>
<ADDRESS>
<ADD>
<STREET>mystree t</STREET>
<CITY>mycity</CITY>
<STATE>mystat e</STATE>
</ADD>
</ADDRESS>
</ROOT>
<ROOT>
<KEY>
<UNID>345</UNID>
<FName>sally</FName>
<LName>mae</LName>
</KEY>
<ADDRESS>
<ADD>
<STREET>herstre et</STREET>
<CITY>hercity </CITY>
<STATE>herstate </STATE>
</ADD>
<ADD>
<STREET>herstre et2</STREET>
<CITY>hercity 2</CITY>
<STATE>herstate 2</STATE>
</ADD>
</ADRESS>
</ROOT>


my xsd looks like this for the address field:

<xs:element name="ADDRESS">
<xs:complexType >
<xs:sequence>
<xs:element name="ADD" maxOccurs="unbo unded" minOccurs="0">
<xs:complexType >
<xs:sequence>
<xs:element name="STREET" type="xs:string " minOccurs="0" />
<xs:element name="CITY" type="xs:string " minOccurs="0" />
<xs:element name="STATE" type="xs:string " minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>

[mchapman13]

Has any one been able to look at this and help me figure out if this is something that is do-able