XSLT from a 'Template XML'



So having tried to work out how to export from MS Access so the resulting XML had the same Element Name and nodes as one that has come from another source.. i have not succeeded..


So am looking at exporting from MS Access to XML and then using an XSLT to transfrom the data in the file so that it can be read.


if anyone could help me because i have tried and failed at coding an XSLT all day to get what i need??


Basically, i need an XSLT created that would transform all XML exports to have the same Element names, and nodes as in my 'Template XML'


My Template XML is as follows...



<DatabaseData>
<Customers>
<Idx>0</Idx>
<FirstName/>
<LastName>Undefined</LastName>
<IconIdx>0</IconIdx>
<PhoneNumber/>
<Email/>
<Street/>
<City/>
<State/>
<ZipCode/>
<Available>1</Available>
<SPIndex>0</SPIndex>
</Customers>
</DatabaseData>

No comments:

Post a Comment