I'm not sure if this is what you need but you could try selecting the
bit you want in the htm file - you'll have to do this with the mouse -
and then hitting Ctrl C for Copy and then pasting it into Notepad and
save it. See what you get. You may be able to import *that* file into
Excel.

A more complex solution could be to use ADO but I'm not sure about
that.