If the Data parameter points to a string, the DataOptions parameter indicates a list of options separated by space character ( or \r, \n or \r\n newline delimiters ) as listed option=value, where the option and the value could be:

• eor, (End Of Row), specifies the delimiter of the row data, \r\n (new-line separator) if missing. You can use the ' or ` to specify the value as a string.
• eof, (End of Field), indicates the delimiter of fields inside the row, \t (tab character) if missing. You can use the ' or ` to specify the value as a string.
• str, (STRing), specifies the characters to delimit the strings in the row data, nothing if missing. You can use the ' or ` to specify the value as a string.
• hdr, (HeaDR), specifies if the data reads the first line as a header to be imported. Could be 1 or 0.

For instance, if the Options parameter is "hdr=0 eof=';'", it indicates that the data in the Source contains no header information, and the fields inside the data are separated by a ; character. If the Options parameter is "eof=';' str=`'`" it indicates that the separator of the fields in the data is ; character while the ' character delimits the strings inside the data.

If the Data parameter points to an array, the DataOptions parameter can be a safe array of strings, that defines the name of the columns to load.

The control can load data using one of the following methods:

• Data, equivalent of Import method
• Import method, loads data from a CSV file, from specified text or from an array
• DataSource property, assigns an ADO/DAO record set to be loaded.