Jun 212009
Excel 2007 comes with the option of querying web to export table data from internet. This is a very good option if you rely on constantly updated data such as exchange rates etc.
Go To Data tab -> From Web. Enter the url of the webpage where table is stored and follow directions. You will have data in your excel sheet.