SQLBindParameter (Excel Driver)
Note
This topic provides Excel Driver-specific information. For general information about this function, see the appropriate topic under ODBC API Reference.
When the Microsoft Excel driver is used, executing an INSERT statement that uses a parameter to insert a NULL into a SQL_CHAR column will return SQL_SUCCESS_WITH_INFO with SQLSTATE 01004, "Data Truncated."