How To Convert Excel Table to XML List for Import to SQL Express?

[htc2010]

We operate a grocery store that runs our front-end database on an NCR product based in SQL Express 2005 on a Windows 2003 server. What we have is a batch of pricing data provided by the state, in plain Excel format, that we currently print out on paper every two weeks. However, I'd like to be able to import this into SQL using the batch function on NCR's software. However, I haven't a clue on how to get this into an XML format readable by the software. I have attached an output of what the XML file is supposed to look like. But I would greatly appreciate any pointers on how to get raw Excel data into that XML file. What throws me off when trying basic tutorials is that this has multiple XML header sections alongside XML for the actual items in the price batch. Most tutorials for Excel only show a simple list without much in terms of headers. Pointers will be much appreciated!