ActiveX

To load a text file that uses other delimiters

Call the LoadTextFile method, setting the parameters as follows:

1. Set the FileName parameter to specify the file name and path of the file to be loaded.
2. Set the CellDelim, ColDelim, and RowDelim parameters to specify the strings used as the cell, column, and row delimiters in the text file.
   For more information about working with delimiters in text files, see the LoadTextFile method.
3. Set the Flags parameter to specify whether the text file provides data to create column headers, row headers, or both.
4. Set the LogFile parameter to the path and file name of the log file that records information about the load process. If you do not want to generate a log file, set the LogFile parameter to "".