Excel 2010 web queries inferior to 2003?

[spursrule68]

I cant seem to be able to extract as many tables. In 2003 I can enter the table number and it will extract the data. In 2010 this table cannot be extracted.

Is there any way to get this table onto my worksheet considering its from 2010?

[martindwilson]

well that's an overwhelming amount of info to go on