---
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: 
  - "Excel driver [ODBC], SQLGetInfo"
  - "SQLGetInfo function [ODBC], Excel Driver"
ms.assetid: fed4aea2-6d3d-4199-a5db-3d033eb63927
author: David-Engel
ms.author: v-daenge
---
# SQLGetInfo (Excel Driver)
> [!NOTE]  
>  This topic provides Excel Driver-specific information. For general information about this function, see the appropriate topic under [ODBC API Reference](../../odbc/reference/syntax/odbc-api-reference.md).  
  
 **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.  
  
## SQL_DBMS_VER  
  
|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_USAGE  
 SQL_FILE_TABLE (Excel 3.0/4.0)  
  
 SQL_FILE_CATALOG (Excel 5.0/7.0)  
  
## SQL_MAX_CHAR_LITERAL_LEN  
 255 (Excel 3.0/4.0/5.0/7.0)  
  
 65535 (Excel 97)  
  
## SQL_MAX_COLUMN_NAME_LEN  
 30 (Excel 3.0/4.0)  
  
 64 (Excel 5.0/7.0/97)  
  
## SQL_MAX_TABLE_NAME_LEN  
 12 (Excel 3.0/4.0)  
  
 31 (Excel 5.0/7.0/97)  
  
## SQL_CATALOG_NAME_SEPARATOR  
 "\\" (Excel 3.0/4.0)  
  
 "." (Excel 5.0/7.0/97)  
  
## SQL_CATALOG_TERM  
 "Directory" (Excel 3.0/4.0)  
  
 "Workbook" (Excel 5.0/7.0/97)  
  
## SQL_CATALOG_USAGE  
 SQL_QU_DML_STATEMENTS | SQL_QU_TABLE_DEFINITION  
  
## SQL_TIMEDATE_FUNCTIONS  
 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