Excel Saved As Web Page Import

I am trying to import spreadsheets from web pages on a regular basis. I do not have any control over their format but they have all been saved as web pages from Excel.

There are two parts to this:
a) Downloading the files
b) Importing the downloads

Right now I am focusing on b) Importing the downloads.

I have tried
1) Using an Excel connection in DTS
2) Using OPENROWSET to access the spreadsheets more directly from TSQL
3) Using a linked server to the file.

All of these seem to use the OLEDB 4.0 provider and they all work if I convert the *.htm file to a *.xls file using Excel first.

With one curious exception none of them work from the *.htm files. DTS is the exception, if I first open the *.htm files in Excel the transformation task succeeds.

I don't really want to use Excel at all on the server. It's strange that DTS does work when the *.htm file is open.

I am trying to get some insight into the various OLEDB options to use hoping that will help me avoid having to use Excel. Perhaps I would just be better off using SQL Server 2005 and SSIS?