Pulling data from a website

[tgavin]

I am working with a db which needs to write some of the PO's in Euro's and
Pounds. Is there anyway to link a table to a currency website and pull the
data into the db on a daily bases by just running a query?

Thanks
Terri

 

[JP]

If I understand your question, you want to get the latest currency
conversion rates into your DB. If so, check out this function:

http://www.codeforexcelandoutlook.com/blog/2010/03/get-currency-conversion-rates-with-web-services/

You may need to adapt it to work with Access.

--JP