CSV import failure Address Book
CSV import failure Address Book
Out of context: Reply #2
- Started
- Last post
- 4 Responses
- vaxorcist0
also, try this:
open file in a text editor, like notepad++ or textpad
see if fields are seperated by ","
if they are, you are in luck:1. find/change "," to "--"
2. find/change , to . (comma to period)
3. find/change "--" back to ","
4. save file with .csv extension
5. import and see if it works
(also see if program allows you to use mac or unix or pc linebreaks, try 1 version of each... i.e. file-mac.csv file-pc.csv file-unix.csv etc....)assume a file like this may be weird, probably came from a non-technical salesguy and you will have to budget a few hours to clean it up...