MDAC 2.5 SDK - ODBC Desktop Database Drivers
| fOption | Comment |
| SQL_ACCESS_MODE | The SQL_ACCESS_MODE fOption can be set to either SQL_MODE_READ_ONLY or SQL_MODE_READ_WRITE. However, the driver does not prevent updates if SQL_ACCESS_MODE is set to SQL_MODE_READ_ONLY. |
| SQL_AUTOCOMMIT | The Microsoft Excel driver only supports SQL_AUTOCOMMIT being set to ON (the default state), because they do not support transactions. |
| SQL_CURRENT_QUALIFIER | Supported. |
| SQL_LOGIN_TIMEOUT | Not supported. |
| SQL_OPT_TRACE | Supported. |
| SQL_OPT_TRACEFILE | Supported. |
| SQL_PACKET_SIZE | Not supported. |
| SQL_QUIET_MODE | Not supported. |
| SQL_TRANSLATE_DLL | Not supported. |
| SQL_TRANSLATION_OPTION | Not supported. |
| SQL_TXN_ISOLATION | Not supported. |