If you run ColdFusion on a Windows NT platform, you can configure a Microsoft Excel database as a data source using ODBC or OLE DB drivers. To complete the connection:
Select options as described in the following table. For the steps involved in configuring your data source, see Configure ODBC data sources.
Field |
Description |
Default |
Data Source Name |
This field displays the name that you entered on the main Data Sources page. You can edit it here. |
Filled |
Description |
Enter a brief description about the data source. |
Blank |
Workbook\Directory |
From the drop-down list, locate and enter the path and filename of the Excel database to which you want to connect. |
Blank |
Version |
Enter the version number of the selected Excel database. ColdFusion supports Excel versions 3.4, 4.0, and 5.0. |
Excel 5.0 |
Driver Settings/Rows to Scan |
ColdFusion determines the data type of each column by the maximum number of types of data found. If data does not match the data type guessed for a column, the data type is returned as NULL.
Enter the number of rows to scan in determining the data type of each column. Enter a number from 1 to 16 for the rows to scan. If you set this field to 0, all rows are scanned. If you enter a number greater than 16, an error is returned. |
16 |
Click Create to save the configuration.