| title | ODBC Jet SQLConfigDataSource (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 | 885b3bea-f4b6-4902-b994-f78a912b612f | ||
| 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.
The SQLConfigDataSource function that is used to add, modify, or delete a data source dynamically uses the following keywords.
| Keyword | Description |
|---|---|
| DBQ | For the Microsoft Excel driver when accessing Microsoft Excel 5.0 or later files, the name of the workbook file. This sets the same option as Database in the setup dialog box. |
| DEFAULTDIR | The path specification to the directory. This sets the same option as Select Directory or Select Workbook in the setup dialog box. |
| DESCRIPTION | A description of the data in the data source. This sets the same option as Description in the setup dialog box. |
| DRIVER | The path specification to the driver DLL. |
| DRIVERID | An integer ID for the driver. 534 (Microsoft Excel 3.0) 278 (Microsoft Excel 4.0) 22 (Microsoft Excel 5.0/7.0) 790 (Microsoft Excel 97-2003) |
| FIL | File type, for example, Excel 3.0, Excel 4.0, Excel 5.0, Excel 7.0, Excel 97, Excel 2000, or Excel 2003. |
| FIRSTROWHASNAMES | Indicates whether the cells of the first row of the range contain the column names for the table (1) or not (0). |
| MAXSCANROWS | The number of rows to be scanned when setting a column's data type based upon existing data. A number from 1 to 16 can be entered for the rows to scan. The value defaults to 8; if it is set to 0, all rows are scanned. (A number outside the limit will return an error.) This sets the same option as Rows to Scan in the setup dialog box. |
| READONLY | TRUE to make file read-only; FALSE to make file not read-only. This sets the same option as Read Only in the setup dialog box. |
| THREADS | The number of background threads for the engine to use. For the Microsoft Access driver, this value defaults to 3, but can be changed. For the dBASE, MicrosoftExceldriver this value is 3, and cannot be changed. This sets the same option as Threads in the setup dialog box. |