Connect to Microsoft Excel database

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:

  1. 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

 

  1. Click Create to save the configuration.

Related topics