How Can I Get excel To Read The Date From An Imported Webpage Table

Hello
I've attached an example of the webpage table after it's been pasted into Excel. I'm wanting to get excel to see the date & the currency pair in the top part of the table. The rest of the table is ok, it's only the 2 fields that are in dropdown menus I need to find a way of getting to. I'll be using VBA to do what I need after that.
This has been copied & pasted from Chrome, but the result is the same if it came from IE. I've tried exporting to excel from IE & it doesn't work. I've also tried importing to Excel via the Data from web button, web address with Chrome & IE with no success.
Any help appreciated
Thanks
Phil