Data source information

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

Database

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

Files

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.

Note:
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.