Q: Use Tab or Comma as delimiters
A: We recommend comma, quote delimited over TAB delimited based on our testing with OAK!Merge 9
Several files that were tab delimited were not importable, but when opened in excel and saved as CSV (comma delimited) they did work. Some TAB delimited fields worked OK.
We have also been able to get some CSVs from excel that would not import, to properly import by opening in ACCESS and exporting from ACCESS as a CSV, setting the field delimiter to a double quote.