vb6 parsing text or html file an put into database

I have a html page with data on it (looks like table format). I need to extract this data and put it into an access database. I saved the html page as a text file. when I open up the text file all of the data is in a single column. I brought ther html file into vb6 dhtml editor. It created the page and they data appears in table format but when you try to extract the data it is in the same column format as the text file. I need to be able to put this single column of data into a table with multiple columns and multiple rows. Attached is the html file and the text file.