Reading an Excel worksheet using ODBC from VB.NET

[David C. Barber]

How do I access an Excel Workbook from VB.NET using the ODBC driver? I want
to read Excel data into a DataGrid control on a web-page. Although ODBC
says it can connect to Excel, it then asks me to design the query in SQL,
and tells me no matter what I specify, that it's wrong.

How do you specify data from Excel via ODBC?
And is it possible to OLE DB as well?

Thanks!

*David*