My Access table has a "memo" field type containing product description, which includes imbedded new lines. User enters data using Access form, new line using Ctrl-Enter, new paragraph using Ctrl-Enter twice.
When table is exported to CSV file (for uploading to an online application), Access breaks the line when it sees the imbedded new line within the product description field. This is (mis)interpreted as a new row by the online application. In example below, the data is interpreted as 3 records (rows) when it is all part of one row.
"120.00","Super Gizmo","This is the best thing since sliced bread. No home should be without one.
Available in Blue, Green and Yellow"
My understanding of CSV is that a new record should be correctly treated as a new row. Therefore the error seems to be that Access is creating new records in the CSV export instead of inserting newline characters? I have done a similar thing with an Excel spreadsheet and multiline cells are saved as a single CSV record.
Need help to get around this problem, i.e. how to save an Access table with multiline fields into a valid CSV file.