Click to return to the Data Access     
Sort     UseHeader     Objects    
Web Workshop  |  Data Access & Databases

TextQualifier Property


Specifies the optional character that surrounds a field.

Syntax

dataobj.TextQualifier = cValue

cValueSingle character string used to surround fields that can include special characters such as newlines, tabs, or commas. These characters can also be active as field or row delimiters. The default value is the double quote character (").

Examples

Comma-delimited text files and similar text data files usually surround text fields in those files with quotes. For example, a simple phone book text file could be arranged like the following:

Fred Nurks, "42 Worldwide Way, Woy Woy", 555-1212
Brianne Hardy, "Apt 3, 14 Hopalong Crescent, Wogga", 555-2121

Normally the commas in the address text would cause the fields to be read incorrectly, but the surrounding double-quote characters avoid that.

Another common use for TextQualifier is when one of the data fields contains HTML text with lots of separate paragraphs (also known as newline characters).

See Also

See also EscapeChar, FieldDelim, RowDelim



Back to topBack to top

Did you find this topic useful? Suggestions for other topics? Write us!

© 1999 Microsoft Corporation. All rights reserved. Terms of use.