I, also could not get an external query to import more than the 1st page.
Perhaps you can ask them?
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MichaelRobert" wrote in message
...
Don:
The url is http://www.awea.org/projects/Projects.aspx?s=California

I want to import the table withe the Header Row beginning
Name/Location/Power Capacity (MW)/

I can import the current page (or sheet) (1), but I cannot get to import
the
other pages which continue the data ...

Mike

"Don Guillett" wrote:


Probably. Give the url and describe the pages you want and/or the steps
you
take to get there.
Often you can record a macro while fetching and then modify the url to
get
the other pages.??
This is the sort of thing I often do for clients.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MichaelRobert" wrote in
message
...
The web table that I want to import is divided into a number of pages
(1-12)
but only the first page is selectable (yellow arrow) in the 'New Web
Query'
window.

I have tried setting up p2 in my browser, and then opening New Web
Query,
but the URL relates to the first page, and I cannot move New Web query
to
the
second or subsequent pages.

Is there a way to import the subsequent pages?

Thanks.

Mike