How i can get currency rates online from web online live to my access fields and tables to get live change in currency rates
Thanks
How i can get currency rates online from web online live to my access fields and tables to get live change in currency rates
Thanks
Well, 'scraping' web pages can be very complicated code. If a website offers an API tool, can be simplified. Review https://www.accessforums.net/showthread.php?t=34620
I am sure there are more threads on the topic, some that even involve currency.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Two options for you from my website
1. Free Currency Exchange Rate Tracker available at http://www.mendipdatasystems.co.uk/cert/4594365453.
That's a standalone ACCDE version. If you want to include it as part of your own app, the source code is available at a low price.
You will also need to obtain a free API key.
You will also need to pay for access to the latest exchange rate data unless you are happy with the free version.
The data is available for download in JSON format and IIRC as CSV or XML if preferred. The app uses JSON data.
2. Live Currency Exchange Rate Ticker - http://www.mendipdatasystems.co.uk/c...ive/4594448827
Hope that helps
Last edited by isladogs; 09-16-2019 at 07:19 AM.
I posted 2 samples getting exchange rates from web site (European Central Bank and TimeGenie) a few(7) years back. These may be helpful.
An alternative to all of the above is to use power query to load a currency exchange rate table from the internet. Close and Load to Excel file and then link the excel file table to Access. Set the connection to update (refresh) each time your Access file opens.