I need a script to pull data from a html page. The data is in a uniform structure in the page. The data is in a table with each containing name, start date, end date, location and id. I need each of those to be dumped into a table with corresponding field names. The id is at the end of the url string for the name. Here is a sample of the data
<table width="600" cellpadding="5">
<tr>
<td><a href="[login to view URL];>Show 1</a></td>
<td>10/25/2007</td>
<td>10/28/2007</td>
<td>New York</td>
</tr>
<tr>
<td><a href="[login to view URL];>some other show</a> </td>
<td>06/26/2007</td>
<td>06/29/2007</td>
<td>SF</td>
</tr>
<tr>
<td><a href="[login to view URL];> 2007 Managers' Conference</a> &nbsp;<font color="FF8000">(Not Participating)</font> </td>
<td>09/10/2007</td>
<td>09/13/2007</td>
<td>Huston</td>
</tr>
</table>
this will be souround by additional html such as a header and footer but its the only table that starts with <table width="600" cellpadding="5">. I need the data pumped into xml or a msSQL table.