The ODBC Excel driver is one of the Microsoft ODBC Desktop Database Drivers (Access, Paradox, dBASE, Text) and follow then the same API.
SQL Grammar and function
The ODBC drivers completely support the Minimum ODBC 2.5 SQL grammar and the clauses in the Core and Extended ODBC 2.5 grammar of this article.
The function (scalar function) are listed here : Scalar Functions. For information about the arguments and return values of scalar functions, see Appendix F of the ODBC Programmer's Reference.
- For a number:
UPDATE Table SET "Column1"=Value1 WHERE "Column2"=Value2
- For a string and datetime
UPDATE Table SET "Column1"='Value1' WHERE "Column2"=Value2
Rows To Scan
The Microsoft Excel Open Database Connectivity (ODBC) driver provides an option called Rows To Scan. This option specifies the number of rows to scan to determine the data type of each column. The data type is determined given the maximum number of kinds of data found. If data is encountered that does not match the data type guessed for the column, the data type will be returned as a NULL value.
The Rows To Scan option will always use the first eight rows of data to determine the data type of a given field regardless of the number of rows specified. In the case where the first 8 rows contain four numeric and four text values, the data type for the column will default to Number.
Select Read Only to prohibit updates to the Excel file.