MACROMEDIA COLDFUSION 5-ADVANCED ADMINISTRATION, Manual, Page: 43 / 372

Connecting to Excel Databases 25
ODBC: MERANT Excel Workbook Driver options
The following table describes ColdFusion ODBC options for data sources created
with the MERANT Excel Workbook driver:
Option Description
Data Source Name A name for your data source.
Description Descriptive information about the data source.
Database Workbook A name that identifies the workbook file containing the Excel
database.
•
International sort Determines the order in which
records display when you issue a Select statement with an
Order By clause.
If you do not select this option, the driver automatically
uses the ASCII sort order. This order sorts items
alphabetically with uppercase letters preceding lowercase
letters. For example, “A, b, C” sorts as “A, C, b.”
If you select this option, the driver uses the international
sort order as defined by your operating system. This sort
order is always alphabetic, regardless of case; the letters
from the previous example would sort using as “A, b, C.”