Reading an Excel worksheet using ODBC from VB.NET

Question posted by: David C. Barber (Guest) on July 17th, 2005 10:20 PM

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*

Quote | Subscribe