exchange rates

[chriske911]

has anyone ever made a database containing exchange rates per date

this so I don't have to reinvent the wheel
and that I can link to it from multiple existing office solutions

thnx

 

[[MVP] S.Clark]

Yes.

 

[chriske911]

[MVP] S.Clark has brought this to us :

Yes.

ok

thnx ;-)

--

no really, I can't find it on your website
could you send me a preview?

grtz

 

[Douglas J Steele]

[MVP] S.Clark has brought this to us :

ok

thnx ;-)

Steve answered your question, which was "has anyone ever made a database
containing exchange rates per date"

You didn't ask "does anyone have a database containing exchange rates per
date that I can copy" <g>

To get specific help, you need to provide more specific questions. How
current do you require exchange rates? By the minute, average for the week,
average for the month and so on.

I'm sure there are samples out there, but I'm afraid I don't have one, nor
did I find one in a very quick search using Google.

 

[chriske911]

Douglas J Steele explained :

Steve answered your question, which was "has anyone ever made a database
containing exchange rates per date"

You didn't ask "does anyone have a database containing exchange rates per
date that I can copy" <g>

To get specific help, you need to provide more specific questions. How
current do you require exchange rates? By the minute, average for the week,
average for the month and so on.

I'm sure there are samples out there, but I'm afraid I don't have one, nor
did I find one in a very quick search using Google.

me neither
that is why I asked ;-)

and I need the XC rates for every day

the problem now is that someone from accounting has to input them in
several systems (boring off course)

and I have made one big application uniting most of these custom appz,
when I am able to put this in some kind of database I could link to it

I have to be able to lookup an XC rate per day and from any currency to
any other currency
on it self probably not that hard but how to design the interface for
an easy input?

grtz

 

[Douglas J. Steele]

and I need the XC rates for every day

the problem now is that someone from accounting has to input them in
several systems (boring off course)

and I have made one big application uniting most of these custom appz,
when I am able to put this in some kind of database I could link to it

I have to be able to lookup an XC rate per day and from any currency to
any other currency
on it self probably not that hard but how to design the interface for an
easy input?

A form that lets you input the date, the currency from and current to codes
(with each being a combo box) and the exchange rate.

 

[Brendan Reynolds]

The Federal Reserve Bank of New York (among others) offer an exchange rate
web service ...
http://www.ny.frb.org/markets/pilotfx.html

There are other institutions offering similar services ...
http://www.google.ie/search?hl=en&q=currency+exchange+rate+web+service

You can call a web service from Access 2002 or Access 2003 by installing the
appropriate version of the Office Web Services Toolkit ...

Office XP ...
http://msdn.microsoft.com/library/d...y/en-us/dnxpwst2/html/odc_offxpwstoolkit2.asp

Office 2003 ...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_wst2003_ta/html/odc_WSTKNew.asp

 

[[MVP] S.Clark]

A client paid big $$$$ for it. It's not like I can just give it away to the
next guy. Sorry.

But feel free to ask questions about it.