ASP parser and recordset

[radujit]

Hi,
I develop in asp a html page parser, and I would need some help.

Here is my code:

<%
Dim objXmlHttp
Dim strHTML
Set objXmlHttp = Server.CreateObject("Msxml2.ServerXMLHTTP")
objXmlHttp.open "GET", "http://somepage", False
objXmlHttp.send
strHTML = objXmlHttp.responseText
%>

Everything works fine, and the result is:

<table>
<tr>
<td>EUR</td>
<td>4.23</td>
</tr>
<tr>
<td>USD</td>
<td>4.19</td>
</tr>
<tr>
<td>AUD</td>
<td>4.20</td>
</tr>
<tr>
<td>NEZ</td>
<td>4.13</td>
</tr>
</table>

Now what I need to do is: for EUR and USD only to insert the values into a database. Practically based on tr,td i need that first td in the tr to be the currency and the second td the value and then these to be inserted into a table in the database.

Please help!
Thank you