I need to parse an HTML page and gather information on it and store it into an Access Database. Here is an example of the HTML I need to parse.
<TD ALIGN="CENTER">
<font face='Arial,Helvetica,Sans Serif' color='#000055' size='2'/>
<!--NNNNNNNNNNNNNNNN-->01456353</FONT></TD>
<!-- END SMU--><TD align="left"><font face='Arial,Helvetica,Sans Serif' color='#000055' size='2'/><B />
<!--NNNNNNNNNNNNNNNN-->Thomas,Halle Michele</TD>
<TD align="center"><font face='Arial,Helvetica,Sans Serif' color='#000055' size='2'/><B /><!--NNNNNNNNNNN-->Enrolled</TD>
I need the ID number after the <!--NNNNNNNNNNNNNNNN--> and I need
the student name after the second <!--NNNNNNNNNNNNNNNN-->
Does anyone have any idea on how to parse this information and store it into the database?