The ODBC Text Setup dialog box contains the following controls, among others:

Data source information

Identifies the file. The Description field, which is blank by default, can contain your descriptive qualifiers.


The default file location. If you want a different location, click Select Directory.


Lists the file name extensions of the text files on the data source. To use all files in the directory, select the Default (*.*) check box. To use only files with specified extensions, clear the Default (*.*) check box and add the extensions you want. When Default (*.*) is cleared, the default extensions are *.asc, *.csv, *.tab, and *.txt.

To add an extension, type the extension in the Extension box and click Add. The extension must use the format *.xxx. For example, to use .dat files, type *.dat. To remove an extension, select the extension in the Extension list and click Remove.

Define Format

Use the Define Text Format dialog box to define the format for columns in a selected file and to specify the schema for each data table.

When the Text driver is used, a file with no extension is created when the CREATE TABLE statement is executed with a name that has no extension. To display files without extensions in the Define Text Format dialog box, "*." must be added to the Extensions List in the ODBC Text Setup dialog box.

Detailed and programmatic information about this driver is located in the MSDN Library. Other information can be found under Data Source Conversion, IISAM Registry Entries, Text ISAM Files, and Common ODBC Component Files in this help file.

See Also