Need help to convert Excel data to XML

[sandy666]

you can try with

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<DataImport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
	<EntityID>EntityID</EntityID>
	<data>
		<date>
			<day>day</day>
			<month>month</month>
			<year>year</year>
		</date>
		<recID>recID</recID>
		<time>time</time>
		<itemSold>ItemSold</itemSold>
		<Price>Price</Price>
	</data>
</DataImport>

as XML schema (not XSD!)
but probably you'll see Denormalized Data error
so I suggest
W3C link
and
Normalizing XML link