Choose Source File and Specify Row Format dialog box
The Choose Source File and Specify Row Format dialog box is displayed when you select File from the Source list on the Mapping dialog box of the Import Wizard. This is where you specify the details about how the data file is set up.
These are the dialog box options:
| Option | Description |
|---|---|
| Text File | Specify the full path and file name or browse to the file. |
| Reset | Clears the text file box. |
| Row Delimiter | Character to indicate the end of each row. The same character must be used throughout the file. |
| Text Qualifier | Character to indicate a text string that contains spaces. |
| Start Import at Row | First row to include in the import. The default is 1. |
| Stop Import at Row |
Final row to include in the import. The default is last. |
| First row has column names | Select this option if the first row of the text file has column names. A header row is not required in structure data. If the data does include a header row, the row does not have to be included in the rows selected for import. |
| Preview | Preview of the text file. This lets you verify the appropriate options are
selected. You should always use the line numbers shown in this area to determine the values for Start Import at Row and Stop Import at Row. If you review your data files in a text editor, you may notice that the line numbers do not match the line numbers as displayed in the Import Wizard. This is likely due to a formula. Some formulas are too long to fit on a single line in some text editors and wrap across multiple lines. The same formula displays on only one line in the Import Wizard. |