The ODBC Microsoft Excel Setup dialog box contains the following controls, among others:
|
Data source information |
Identifies the Excel file. The Description field, which is blank by default, can contain your descriptive qualifiers. |
|
Database |
Use these options to change the default file location. If another location is desired, click Select Directory or Select Workbook, depending on which Excel product version you selected in the Version box. |
|
Driver |
Rows to Scan specifies the number of rows that Setup or the driver will scan when setting the columns and column data types. This can be any number from 1 to 16. Select Read Only to prohibit updates to the Excel file. |
 Note: |
|---|
|
Detailed and programmatic information about this driver is located in the MSDN Library. Other information can be found under Data Source Conversion, Excel Files, IISAM Registry Entries, and Common ODBC Component Files in this help file. Product support is available.
|