307261 xml expert

I need someone to help me on this project. We are supplier. In summary, we need to be able to read the XML file (e.g. [login to view URL], [login to view URL]) from a folder and import the data to our database table(MSSQL). When we export out the XML file, our schemas is not same as their schema.(Please refer to our schema). How can we turn the data in our schema to display in the schema their want like this? 5000038032 ACK 2006-03-28 13:27:01 1234567 2083133 Please advise.