[2008] Save webpage table to dataset

**Xancholy** · Jul 15th, 2008, 11:22 AM

I would like to transfer the contents of a url webpage-based table to a dataset.

Using a webbrowser I navigate to the webpage
I then need to zero in on the table and trap the contents to a dataset

Can anyone please show me how to achieve this ? PS: this is a paid membership site - so this is all legal.

Image attached....

Here is the webpage html...

Code:

<html>
<head>
</head>
<body>
<table border="0" cellpadding="0" cellspacing="0"
 width="800">
  <tbody>
    <tr>
    </tr>
    <tr>
      <td class="SongDetails_Table_Content" bgcolor="#ffffff"
 valign="top">
      <table border="0" cellpadding="5" cellspacing="0"
 width="397">
        <tbody>
          <tr>
            <td>
            <input value="3350395" name="song_id"
 type="hidden"><input value="2" name="history"
 type="hidden">
            <table border="0" cellpadding="5"
 cellspacing="0" width="100%">
              <tbody>
                <tr>
                  <td colspan="2">
                  <h1>This is My Song</h1>
                  </td>
                </tr>
                <tr>
                  <td class="Header">Song Number</td>
                  <td class="CopyrightInfo">3350395</td>
                </tr>
                <tr>
                  <td class="Header" valign="top">Authors</td>
                  <td class="CopyrightInfo">
                  <a
 href="SearchResults.cfm?search_type=byAuthor&amp;searchby=byAuthor&amp;searchConsole=basic&amp;author_first_name=Keith&amp;author_last_name=Getty&amp;search_method=exact&amp;search_words="
 title="Click to search for all songs by this Author">Jon
Vangelis</a><br>
                  <a
 href="SearchResults.cfm?search_type=byAuthor&amp;searchby=byAuthor&amp;searchConsole=basic&amp;author_first_name=Stuart&amp;author_last_name=Townend&amp;search_method=exact&amp;search_words="
 title="Click to search for all songs by this Author">Crazy M</a>
                  </td>
                </tr>
                <tr>
                  <td class="Header" valign="top">Copyright</td>
                  <td class="CopyrightInfo">
2001 Whatya Music (Admin. by JMI Music Publishing)
                  <br>
                  </td>
                </tr>
                <tr>
                  <td class="Header" valign="top">Catalog</td>
                  <td class="CopyrightInfo">
                  <a
 href="SearchResults.cfm?searchby=byCatalog&amp;search_type=byCatalog&amp;catalog_id=GC23677&amp;search_method=exact&amp;search_words="
 title="Click to search for all songs in this Catalog">Whatya
Music</a>
                  </td>
                </tr>
                <tr>
                  <td class="Header" valign="top">Administrator</td>
                  <td class="CopyrightInfo">
                  <a title="Click to open this Admin's web site"
 target="_blank"
 href="/CCLI_Services/Tags/ToURL.cfm?url=resources.worshiptogether.com/SongSelect/&amp;type=AdminLink&amp;songid=3350395&amp;id=P10336">JMI
Music Publishing</a>
                  <br>
                  </td>
                </tr>
                <tr>
                  <td class="Header">Key</td>
                  <td class="CopyrightInfo">Eb</td>
                </tr>
                <tr>
                  <td class="Header">Key Line</td>
                  <td class="CopyrightInfo">I'm telling
ya, this is my song</td>
                </tr>
                <tr>
                  <td class="Header" valign="top">Also
Known As</td>
                  <td class="CopyrightInfo">
What areyou saying <br>
Själv (Swedish)
                  <br>
Whatya (German)
                  <br>
Bouw Op Hem (Dutch)
                  <br>
AleneDeg (Norweigen)
                  </td>
                </tr>
                <tr>
                  <td class="Header" valign="top">Themes</td>
                  <td class="CopyrightInfo">
Individuality <br>
Survival
                  </td>
                </tr>
                <tr>
                  <td colspan="2">
                  <hr color="#6699ff" noshade="noshade"
 size="1"></td>
                </tr>
                <form method="get" action="">
                  <tr>
                  </tr>
                </form>
              </tbody>
            </table>
            </td>
          </tr>
        </tbody>
      </table>
      </td>
    </tr>
  </tbody>
</table>
</body>
</html>

Thread: [2008] Save webpage table to dataset

Thread Tools

Display

Threaded View

[2008] Save webpage table to dataset

Posting Permissions