In Text qualifier, select the character that encloses values in your text file, which is most often the quote (') character. Select Treat consecutive delimiters as one if your data contains a delimiter of more than one character between data fields or if your data contains multiple custom delimiters. If you chose Delimited on the first page, under Delimiters, select the delimiter character or use the Other check box to enter one not listed.
In most cases, you can leave this setting at its default. Row Number In Start import at row, select a row number to specify the first row of data that you want to import.Ĭharacter Set In File origin, select the character set that is used in the text file. Tip Repeatedly check the Preview of selected data pane to confirm your choices.įile Type To choose the type of text file, select Delimited or Fixed width. If the Grant File Access dialog box appears, select Select, and then select Grant Access to the top-level folder containing the data source files.
If you get a security warning about external data connections being disabled, select Enable Content.
