The Generic Microsoft Excel Adapter models Excel workbooks as relational databases. Spreadsheets and ranges comprise the tables.
Executing SQL to Spreadsheets
Excel Operations shows various ways to work with spreadsheet data.
Advanced Data Modeling
You can fine-tune the data model to match your workbook's organization. The adapter supports reading data that is oriented vertically or horizontally, as well as sparse spreadsheets organized in user-defined ranges and named ranges.
See Fine-Tuning Data Access to configure the connection string to control the tables the adapter discovers, return values, and other aspects of data access.