How to take values in XML file from server and update database daily

Dear all please help me in the following;

I have an XML file from middle ware (server) will be received to my Database queue. The XML file hold currencies and I need to update them daily! in this way

update Currency   set currencyValue = 0.0000
where currencyName='USD'

My question is! how can I take the value from the XML file and update it in my Database regularly. also I am I going to use XML or SQL ?

basically I need to interface the two programs.

Best regards,