_QueryTable.TextFileConsecutiveDelimiter Property
True if consecutive delimiters are treated as a single delimiter when you import a text file into a query table. The default value is False. Read/write Boolean.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property TextFileConsecutiveDelimiter As Boolean
Get
Set
'Usage
Dim instance As _QueryTable
Dim value As Boolean
value = instance.TextFileConsecutiveDelimiter
instance.TextFileConsecutiveDelimiter = value
bool TextFileConsecutiveDelimiter { get; set; }
Property Value
Type: System.Boolean
Remarks
Use this property only when your query table is based on data from a text file (with the QueryType property set to xlTextImport), and only if the value of the TextFileParseType property is xlDelimited.