csv

SGS Export line breaks divide records

When a selection of SGS data is exported to a csv file, the records with carriage returns and/or commas are divided in two parts and screws the filtering and pivoting of the data in excel.

MS Access Truncating Exports of Memo Fields at 512 Characters

Recently I was surprised to find that exports of Memo fields to csv and txt truncate at 512 characters.

Thankfully, there is an easy, albeit poorly documented hack.  In the export wizard set "Text Qualifier" to "{none}"