|
|
The table below shows the first few lines from your file. It may not look very organised at this stage, but at this point all you need to do is tell the Wizard how many lines to ignore at the start of the file.
Usually when you import from a file, the first line isn't actual data but tells you the field names or column headers. You will want to skip this line when you do the actual import, so change the value in the Start importing from row: box in order to skip one or more lines, if that's relevant.
If the first line of your file is real data, set the value to one.
The Import Wizard does not support fixed-width fields, only delimited fields. |
|
|
Click the Settings button to access advanced settings.
By default the Wizard will trim any spaces from the beginning and end of every field. To prevent this, untick the Remove trailing spaces from fields option, although bear in mind that spaces are irrelevant and usually appear by accident.
Normally a database only contains one address per line, and that's the default for the Import Wizard. However if your database contains more than one address per line, change the Max addresses per record setting accordingly, up to a maximum of 10 addresses. |