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 2 2772
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.co m
"strychtur" <jo********@gma il.comwrote in message
news:11******** **************@ x35g2000prf.goo glegroups.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
"strychtur" <jo********@gma il.comwrote in message
news:11******** **************@ x35g2000prf.goo glegroups.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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: laurie |
last post by:
Hi all,
I'm trying to help out a friend who has inherited a client with a PHP
shopping cart application. Neither of us know PHP, but I've been
muddling my way through, trying to get these old scripts working on a
new server with the most recent version of PHP. I've pretty much
taken care of all the various errors that were popping up. Most only
pointed out out non-fatal undefined or assumed variables. I've been
able to cure most of...
|
by: Jason |
last post by:
I have a table that matches up Securities and Exchanges. Individual
securities can belong on multiple exchanges. One of the columns, named
PrimaryExchangeFlag, indicates if a particular exchange is the primary
exchange for that symbol. Each symbol can only have one primary
exchange.
I am trying to write a insert/update/delete trigger that enforces this
rule. The rules I have thought of are as follows:
Insert If new row has flag...
|
by: Baybars |
last post by:
New to access, but to deja.com. Looked through many posts, but can not
find a good post for my problem (I believe there is, but my access
level didn't allow me to understand).
I have a table for cash flow of a shop. Forreign currencies are
accepted. I built the tables accordingly: CURRENCY TYPE (USD, EURO,
POUND ETC), AMOUNT OF THE CURRENCY. RATE FOR LOCAL CURRENCY and LOCAL
CURRENCY VALUE.
When I entered the type of currency (eg USD),...
|
by: Dan Kean |
last post by:
Hi all, anyone know how I can create a currency table from a website with up
to date exchange rates .
the system I'm working on needs to store the exchange rates (compared to
GBP) every month on a set date. Each month the exchange rates need to be
imported into a new table-not replacing the old exchange rates
All help appreciated
Dan
|
by: Mark Harrison |
last post by:
So I have some data that I want to put into a table. If the
row already exists (as defined by the primary key), I would
like to update the row. Otherwise, I would like to insert
the row.
I've been doing something like
delete from foo where name = 'xx';
insert into foo values('xx',1,2,...);
| |
by: meenasamy |
last post by:
Hi all, i need to create a function that takes three parameters(
Original currency, needed currency, amount) i need to convert from the
original currency to the needed currency the amount and return the new
amount in the needed currency, I need this function to work real time
(obtaining real time currency exchange rates), any ideas???
|
by: monomaniac21 |
last post by:
Hi i want to display the price of a product on my site in multiple
currencies that is constantly updated to keep in line with exchange
rate fluctuations can anyone tell me how i could get access to basic
exchange rate data automatically for my site? (just a few major
currencies)
Kind regards
Marc
|
by: Eric |
last post by:
I've built a Currency class, more or less like Java's, a Money class to
handle rounding and allocation, and a Moneybag that should collect
different monies and convert them to a given exchange rate on demand.
Anyone encapsulated a strategy for capturing and using exchange rates in a
Converter type object? Ideally this would know how to look up some well
known web service and get the rate given the currency.
Much thanks in advance,...
|
by: annCooper |
last post by:
Exchange Rates
Source file: Exchange.cs
Input file: Exchange.in
Output file: Exchange.out
Using money to pay for goods and services usually makes life easier, but sometimes people prefer to trade items directly without any money changing hands. In order to ensure a consistent "price", traders set an exchange rate between items. The exchange rate between two items A and B is expressed as two positive integers m and n, and says that m of...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |