Although I haven't used it myself for this purpose, I know that ADO supports web access using the Internet Publishing Provider.
I've seen reference to using ADO for this purpose at ExtremeVBtalk. There's also a chapter in Rob MacDonalds excellent book "Serious ADO: Universal Data Access with Visual Basic" (APress)
You would need to write a VBA module to retrieve the data.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert