CData TDV Adapter for Microsoft Excel
Generic Microsoft Excel Adapter
Generic Microsoft Excel Version Support
The Generic Microsoft Excel Adapter supports the Office Open XML spreadsheets used by Microsoft Excel 2007 and later.
Generic Microsoft Excel File Extension Support
The Generic Microsoft Excel Adapter currently supports .xlsx and .xlsm files. However, only read operations are supported for .xlsm files. Modifying data operations may cause loss of or damage to macros.
SQL Compliance
The
SQL Compliance section shows the SQL syntax supported by the adapter and points out any limitations.