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.