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. |