Frequently asked questions for self help.
Knowledge base article 78How to import ASCII text
ASCII or plain text must include a header line denoting field names. An example of the ideal format is as follows:
"Phil", "Roach", "Ability Plus Software", 37
"John", "Speak", "", 45
"Charles", "Stuart", "House of Stuart", 498
It is good practice to surround text fields by double quotes
If a text field is blank, still enter both sets of quotes (see line 3 in above example)
Numeric fields do not require quotes
Each record must begin on a new line
Commas must be used to separate fields
You can check the format of the data you are trying to import using Notepad (Start/Programs/Accessories/Notepad). If necessary, manually add the field names at the top of the data.