Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 :-(. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automating import of Word tables into Excel | Excel Discussion (Misc queries) | |||
Page numbering multiple worksheets in a file without affecting set | Excel Worksheet Functions | |||
Multiple Pivot tables from One selection | Excel Discussion (Misc queries) | |||
Web Query from multiple tables | Excel Discussion (Misc queries) | |||
data before page break lost during import | Excel Discussion (Misc queries) |