How to import a table on a Web page to Excel?

  • Thread starter Dmitry Kopnichev
  • Start date
D

Dmitry Kopnichev

Hello
How to import a table on a Web page to Excel? Columns in the table are
delimited by several spaces, not by a htm table tag.
 
D

Dmitry Kopnichev

The table in the webpage looks as a table, but it is a text with columns in
the table delimited by several spaces, not by a htm table tag. Therefore,
the no. of the table cannot be found out from the source html page counting
<table> tag, can be? The table is between other text.
 
D

Dmitry Kopnichev

Clicking <Click to select this table> in the dialog box <new web query>
selects all text on the page, not just the table. There are other tables
(with columns delimited by spaces)separated by text on this page. I need the
other tables too.
 
D

Dmitry Kopnichev

Clicking <Click to select this table> in new WebQuery window imports all
text, not only tables, without separating to columns.
 
D

Dmitry Kopnichev

How to import tables only, not all text? Clicking <Click to select this
table> in new WebQuery window imports all text, not only tables.
 
Top