To ensure the connection is working, enter some data, and then select Connections > Refresh. The Import Data dialog box appears.Ĭhoose where you want the data to be added: either on the existing sheet, on a new sheet, or in a PivotTable. You can also convert the data after you import it. You can further set the date format and select Advanced to change numeric data settings. If you chose Fixed width on the first page, follow the instructions to create, delete, or move a break line in the Preview of selected data box.įor each column under Preview of selected data, select it, and then change it to a different column format if you want. 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.
0 kommentar(er)
