Reading an Excel spreadsheet using ADO.NET

Sample code illustrating how to connect to an Excel spreadsheet data source using ADO.NET.

The binary can be used to test connecting to spreadsheets; it supports sheets, sheets with ranges, and named ranges. Arbitrary select statements may be executed; the results are displayed along with the connection string used.

Supports Excel 5.0, 95, 97, 2000, 2003, and 2007 (all three variants). Comments in the code point to additional resources.


No comments: