By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,544 Members | 2,065 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,544 IT Pros & Developers. It's quick & easy.

Update exchange rates

P: n/a
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

Aug 9 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"strychtur" <jo********@gmail.comwrote in message
news:11**********************@x35g2000prf.googlegr oups.com...
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

Aug 9 '07 #2

P: n/a
"strychtur" <jo********@gmail.comwrote in message
news:11**********************@x35g2000prf.googlegr oups.com...
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?sourc...web+service%22
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Aug 9 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.