The CData SSIS Components for Microsoft Excel 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 component 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 component discovers, return values, and other aspects of data access.

Stored Procedures

In addition to working with the data in the spreadsheet, you can use the available stored procedures to change the metadata of an Excel file.