Carriage return in a CSV file

[btidwell3]

To All,



I am using the Access 2003 text exporter to create a CSV file. The end user has requested the addition of a carriage return at the end of each line. There is already a line feed at the end of each line.

What is the easiest way to add the CR?

Thanks in advance.

Bill T.

[orange]

In vba you can use vbCrLf (intrinsic) to add a carriage return and LineFeed to a record.

Force carriage return in string Modules & VBA. ... Chr(10) returns a linefeed character. Chr(13) is a carriage return

If you added a Line feed by appending a Chr(10), you could read your file and append a Chr(13) to each record.