Update exchange rates

[strychtur]

Hi All,
Right now we get a daily email with the current currency exchange rate
in it. Then someone copies that data into a SQL Sever table every
day. I am looking to automate this process. The source of the exchange
rate does not have to be the email. I would like the server to update
the rates once every day. Can someone help me?

Thanks a bunch for your help.
John

 

[Nicholas Paldino [.NET/C# MVP]]

John,

Which server would you like to update the rates? If you are not getting
the rates from the email, then where are you getting them from?

It sounds like at the least, you might want to set up some stored
procedures which will take your data and update the database, either on a
record-by-record basis, or in a bulk manner,

Speaking of bulk manner, you could generate a comma-delimited file, and
then do a bulk import into your database table as well.

Once you have these things in place, calling the routines from code is
simple.

 

[Mark Rae [MVP]]

Right now we get a daily email with the current currency exchange rate
in it. Then someone copies that data into a SQL Sever table every
day. I am looking to automate this process. The source of the exchange
rate does not have to be the email. I would like the server to update
the rates once every day. Can someone help me?

Which organisation supplies you with the exchange rates?

I work with this type of data quite regularly, and there are dozens of feeds
that you can use.

These days it's virtually unheard of for a supplier of financial data like
this not to offer feeds via a web service - that is certainly the most
efficient solution:
http://www.google.co.uk/search?sour...GBGB220GB220&q="exchange+rates"+"web+service"