View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default How import multiple tables from same web page (Web Query)?

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/portal...0026b4bf0aRCRD .
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 :-(.