Linking a database up with xe.com

Hi Nicholas, thanks for your query. The quickest way to do this would be to use Excel to perform a web query. On a new spreadsheet click the Data tab and choose "From Web" on the left hand side. In the browser that appears type in the xe.com web address and click Go. The website should appear. Look for a yello arrow top left of the page and click it so it selects the entire page. Then click import, choose a single cell from which to build the page and click OK.

The result will be a mess, because the xe.com website has nested the exchange rates, making them more difficult to get to. However, if you scroll down you should find the rates have been brought onto the sheet in the form of a table. You next task is to link this spreadsheet into you access database as usual. The web query in Excel will refresh every time you open the spreadsheet, thereby transporting the latest rates into Access.

Try looking for a different, simpler site (try Yahoo Finance) to get the exchange rates. You want the yellow arrow to only select the single table you're interested in, not really the entire page.

Hope this helps,

Anthony