Exchange rate updation before Printing Report

[iranbir]

HI,

Updating Exchange Rate before printing the Report

I have a table tbl_LCData, which stores Exchange Rate (EXRATE)

Since the exchange rate fluctuates, we need to update the EXRATE before printing the report rpt_LimitAvailable, which will help us for planning the outstanding amount on due date.

We want to update the rates online from site http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml

Sample Data Attached

Thanks


Ranbir

[June7]

So what do you need help with? How to download data from web into Access?

You download the data as an xml file? Access can import XML. However, I did a test with your example xml and it didn't import nice. Might have to use text field read/write methods to parse the file and save data to table.

[iranbir]

hi,

Thanks for prompt reply.

I need help on how to download and update it in the database, need to update exchange rate only USD and EURO.

[isladogs]

Or you could use my currency exchange rate tracker which imports data from downloaded JSON web files.
The data is updated from the ECB daily.

The app is available free from http://www.mendipdatasystems.co.uk/free-apps/4592091376 as an ACCDE file
An ACCDB version with full code is also available for a small cost

[iranbir]

hi,

thanks

kindly advise how to connect this to database, however when we change the currency to INR its showing error Data type mis-match

[isladogs]

Hi

You would need to purchase the code to link or import it into your database.

EDIT:
Thank you for pointing out the bug which I have just fixed
Fixed version 1.33 is now available from the same site: http://www.mendipdatasystems.co.uk/free-apps/4592091376