The Import File (also commonly referred to as the source data file) contains the records to be imported. The file should be either an ASCII quote/comma delimited or tab delimited file format in order for the data to be properly imported.
The Tilde (~) character should not be present in any field. It is recommended that the Quote (") character not be present either.
The most common file extension is .CSV (which can be created using a variety of software tools including MS Excel).
The fixed width file format is NOT supported by the Data Importer.
Blank lines in the Import File being imported are skipped to prevent blank records from being created (blank lines are sometimes accidentally added to the end of text files created for importing database records).
See:
Data Importer Contents