DelimitedAscii
Object List Hierarchy Next Object
Definition:
Used to define table properties for an ASCII text file. A Row and Column
string delimiter is used to define the table's Row and Column fields within the text
source.
Specialized Features:
The following tables list and describe the properties and methods added by DelimitedAscii. There are no added events.
Properties Use to...
Connect Open and attach an ASCII text file with delimiter-separated fields.
FieldDelimiter Separate fields of ASCII text with a character string.
FieldDelimiterExpr Define the marker for the end of each field.
FirstLineAsFieldNames Indicate whether the first line of the text file is to be used as the
FieldNames for the Dynaset and RecordSet methods that reference field names.
RowDelimiter Separate rows of ASCII text with a character string.
RowDelimiterExpr Define the marker for the end of each column using a regular expression.
Methods Use to...
Disconnect Close the connection to the ASCII text file.
Copied Features:
None
this is a top-level object.
Details:
A DelimitedAscii object is similar to a FixedAscii object with one major
difference. A FixedAscii forces all Fields to be set to a specified size. The
DelimitedAscii employs a field delimiter that allows the length of entries in the
same columns to vary from row to row. The FixedAscii is a faster structure than
the DelimitedAscii, since the beginning and end of each entry are fixed. The
speed difference is more noticeable when working with larger databases. The freedom
to make entries of any size makes the DelimitedAscii more appropriate for
databases with irregular length entries, such as user names and passwords.