How import multiple tables from same web page (Web Query)?

[Guest]

I want to import multiple tables from the same web page
that I find with a google search. Is there an easy way to
do that?

This is what I did (sigh). Click on Data > Import External
Data > New Web Query, go to google.com and search for
"1926 s&p 500" without quotes. Click on the link for "AIM
Investments: How to Survive the Stock Market's Ups and
Downs" at
http://www.aiminvestments.com/porta...Guid=a03abb4011db2010VgnVCM10000026b4bf0aRCRD .
Page down to the several tables under the titles "The Stock
Market: The Good Years" and "... The Bad Years". Select one
table and click Import.

I have to repeat the whole thing, including the Google search,
for each table :-(.

 

[Guest]

I have to repeat the whole thing, including the Google search,
for each table :-(.

PS: Cut-and-paste of the AIM URL did not work. That is,
cut-and-paste was not allowed into the New Web Query
address field, at least not with right-click.

PPS: Save Query and re-running the saved query did not
do what I want. I imported the entire AIM page.

 

[Guest]

I want to import multiple tables from the same web page
that I find with a google search. Is there an easy way to
do that?

Okay, sounds like a "dumb" question. I simply have click on
multiple "->" handles next to each table.

But what if I what to control the placement of each table?

The point of my inquiry was: is there an easy way to revisit
a web page used for a web query, given the complex sequence
of steps that it takes to get to that web page? (See my
original posting.)