Question: The system used to export-import csv files goes without a hitch, but lately I have been having problem with importing csv files to MYOB.
When I imported a csv file that has been edited in MsExcel, the system added quotes on some data field (customer name, item descriptions, etc). I tried specifying Excel on how to open the csv file (tab delimited=quotes, etc) but the quotes reappear when imported back to MYOB. In Excel the data looks fine.
Answer: A very common problem with any file type being imported to MYOB! In Excel use Search and Replace to replace all commas or other punctuation with a space (use space bar). Then import. It should come through cleanly this time.
NB: always backup before importing.
Related posts: