Import External data from a Website

[MichaelRobert]

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

 

[Don Guillett]

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.

 

[Shane Devenshire]

Hi,

I'm not sure what the problem is, when I do a new web query and arrive on a
web page, I can easily navigate to another page or type in the URL in the
Address line and Excel brings that page in.

Maybe by page you don't mean a separate web page?

Thanks,
Shane Devenshire

 

[MichaelRobert]

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]

I, also could not get an external query to import more than the 1st page.
Perhaps you can ask them?

 

[MichaelRobert]

Thanks, Don. I'll contact them.

Have you been successful in the past in importing the full table when it is
presented in multiple sheets like this? I'd like to know if I am dealing with
a site-specific problem or a general problem with this type of data
presentation.

Mike

 

[Don Guillett]

Generally speaking, IF you can get a different url when you change the page
on line you can build a looping macro to get each page and extract data as
desired. I often do this for clients using external queries.