| title | SQLGetInfo (Excel Driver) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 01/19/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | connectivity | ||
| ms.reviewer | |||
| ms.technology | connectivity | ||
| ms.topic | conceptual | ||
| helpviewer_keywords |
|
||
| ms.assetid | fed4aea2-6d3d-4199-a5db-3d033eb63927 | ||
| author | David-Engel | ||
| ms.author | v-daenge |
Note
This topic provides Excel Driver-specific information. For general information about this function, see the appropriate topic under ODBC API Reference.
SQLGetInfo supports the SQL_FILE_USAGE information type. The returned value is a 16-bit integer that indicates how the driver directly treats files in a data source:
-
SQL_FILE_NOT_SUPPORTED - The driver is not a single-tier driver.
-
SQL_FILE_TABLE - A single-tier driver treats files in a data source as tables.
-
SQL_FILE_QUALIFIER - A single-tier driver treats files in a data source as a qualifier.
The ODBC driver returns SQL_FILE_TABLE for theMicrosoft Exceldriver because each file is a table.
| ISAM | Version | Format of version numbers |
|---|---|---|
| Microsoft Excel | 3.0 | 03.00.0000 |
| 4.0 | 04.00.0000 | |
| 5.0/7.0 | 05.00.0000 | |
| 97/2000 | 08.00.0000 |
SQL_FILE_TABLE (Excel 3.0/4.0)
SQL_FILE_CATALOG (Excel 5.0/7.0)
255 (Excel 3.0/4.0/5.0/7.0)
65535 (Excel 97)
30 (Excel 3.0/4.0)
64 (Excel 5.0/7.0/97)
12 (Excel 3.0/4.0)
31 (Excel 5.0/7.0/97)
"\" (Excel 3.0/4.0)
"." (Excel 5.0/7.0/97)
"Directory" (Excel 3.0/4.0)
"Workbook" (Excel 5.0/7.0/97)
SQL_QU_DML_STATEMENTS | SQL_QU_TABLE_DEFINITION
SQL_FN_TD_CURDATE | SQL_FN_TD_CURTIME | SQL_FN_TD_DAYOFMONTH | SQL_FN_TD_DAYOFWEEK | SQL_FN_TD_DAYOFYEAR | SQL_FN_TD_HOUR | SQL_FN_TD_MINUTE | SQL_FN_TD_MONTH | SQL_FN_TD_NOW | SQL_FN_TD_SECOND | SQL_FN_TD_WEEK | SQL_FN_TD_YEAR