Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 :-(. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How import multiple tables from same web page (Web Query)?
I wrote:
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How import multiple tables from same web page (Web Query)?
I wrote:
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.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |