Import Options String

 

The Import Options string consists of a series of semicolon-separated keywords that specify the behavior of the import. A typical example would be:

 

 " Delimiter=comma; TextQualifier=singlequote;SkipExtraDelimiters=0"

 

This would set the delimiter character to a comma and the text qualifier character to the single-quote mark ( ' ).

 

Option

Action

Default

Sheet

Opens the specified sheet in an Excel workbook

 

Delimiter

Character that separates data cell values. You can use more than one delimiter in the string. For example, " Delimiter=comma,%,tab"

comma

TextQualifier

Specifies the character that surrounds cells containing text. You can use more than one text qualifier in the string. For example, " TextQualifier=doublequote,~"

doublequote

SkipExtraDelimiters

Specifies whether multiple delimiters are treated as one delimiter.

 

EatWhiteSpace

Removes extra space and tab characters preceding and following data

0

 

Delimiter values:

tab

Enter the word "tab"

comma

Enter the word "comma"

semicolon

Enter the word "semicolon"

space

Enter the word "space"

other

Enter the delimiter character in the delimiter list. For example, if your file uses percent signs to delimit data add a " Delimiter=%" to the import options string.

 

TextQualifier values:

doublequote

Enter the word " doublequote"

singlequote

Enter the word " singlequote"

none

Enter the word "none"

other

Enter the text qualifier in the qualifier list. For example, if your file uses percent signs to qualify text add a " TextQualifier=%" to the import options string.

 

SkipExtraDelimiters values:

0

Skip extra delimiters in the data. For example 1,,2,,,3 would import into columns A, B, and C.

1

Do not skip extra delimiters in the data. For example 1,,2,,,3 would import into columns A, C, and F.

 

EatWhiteSpace values:

0

Do not skip extra space and tab characters in the data. For example " 1 2" would leave column A blank and would import values into columns B and C.

1

Skip extra space and tab characters in the data. For example " 1 2" would import into columns A and B.