Support Article

Issue while loading MS Access Export



he text file generated by the Acces export uses "" as a text identifier. This is required due to a comma being used within the filed for the rules, because without the text identifier the commas within this field are treated as delimiters.

Error Messages

Not applicable

Steps to Reproduce

1. Export .txt file from Access.
2. Open with Excel.

Root Cause

  Double quote characters are optional and often omitted for the values that do not contain a comma character.



As a work around, if double-quotes are used to enclose fields, then a double-quote appearing inside a field might be escaped by preceding it with another double quote.

Published September 9, 2016 - Updated September 19, 2016

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.