I use Excel web queries to pull in data from the web. Unfortunately more and more sites are desisting from using tables to structure their web pages, making it hard to just pull in the data I want. For example, I want the Bank of England base rate, which is published on their home page. But not in a table. And I've yet to discover a site where it is published in a reasonably small table.
What's the best way forward if one can't find a site that publishes desired data in a table?
What's the best way forward if one can't find a site that publishes desired data in a table?
Comment