2007 Office System Driver: Data Connectivity Components
| File Type | Extended Properties | | :--- | :--- | | Excel 97‑2003 Workbook (.xls) | Excel 8.0 | | Excel 2007 Workbook (.xlsx) | Excel 12.0 Xml | | Excel 2007 Macro‑enabled workbook (.xlsm) | Excel 12.0 Macro | | Excel 2007 binary workbook (.xlsb) | Excel 12.0 | 2007 office system driver data connectivity components link
: Includes Object Linking and Embedding Database providers for application integration. 2007 Office System Driver: Data Connectivity Components |
This driver system is utilized in several distinct enterprise scenarios: 1. Connecting SQL Server to Excel/Access This allows users to run T-SQL queries directly
Database administrators frequently use these components to create Linked Servers in SQL Server. This allows users to run T-SQL queries directly against an Excel spreadsheet or an Access database file without importing the data first. 2. Extract, Transform, Load (ETL) Operations
If connecting to Excel, use Extended Properties="Excel 12.0" in your connection string.