Hello All,
I need some direction with regards to LIVE (Real Time access to currency exchange rates) for use in my DB queries. I have some reports which have figures in (Amount, Currency) which any Amounts in dollars and euros need converting into pounds sterling at whatever the rate is.
I can do this manually but REALLY dont want to!
I have read up on Web Services using currency:
http://msdn.microsoft.com/en-us/library/ms365190(SQL.90).aspx
This looks a little too involved for our level of expertise! So I have found an XML format with the info I need:
http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml
I can use this XML and convert into a SQL Table but the issue I have is I want the XML file to be updated automatically from this website without manual intervention. How can I do this, or is there an easier way to get what I need.?
Please Help!