how do I download currency exchange rates

[Tom]

I am looking for a way to automatically download currency exchange rates into
my Access 2003 database. I have found an Excel macro that calls a web
service that works great, but I cannot find a similar macro for Access. I
would like to be able to grab the rates from the MSN Money website and
automatically fill them into an Access table. Has anybody done this?

Thanks

 

[Brendan Reynolds]

I am looking for a way to automatically download currency exchange rates
into
my Access 2003 database. I have found an Excel macro that calls a web
service that works great, but I cannot find a similar macro for Access. I
would like to be able to grab the rates from the MSN Money website and
automatically fill them into an Access table. Has anybody done this?

Thanks

I haven't used that particular web service, but I've used other web services
with Access. Here are some of the replies I've posted in the past to
questions on this topic, perhaps you might find some of them useful.

http://groups.google.ie/groups?as_epq=web+service&as_uauthors=Brendan+Reynolds