TextFileParseType Property

         Example         Applies To

Returns or sets the column format for the data in the text file that you’re importing into a query table. Can be one of the following XlTextParsingType constants: xlDelimited (indicating that the file is delimited by delimiter characters) or xlFixedWidth (indicating that the data in the file is arranged in columns of fixed widths) The default value is xlDelimited. Read/write XlTextParsingType.

Remarks

Use this property only when your query table is based on data from a text file (with the QueryType property set to xlTextImport).