I need to remove carriage returns from a table via a query which is in turn being converted in to a csv file ready for import. As you can imagine a carriage return causes major problems when trying to import.
I am using the following method Replace([Street Name],Chr(10),", ")
This does work but for some reason converts the carriage return to a ? in a box symbol. When reviewing the CSV, the carriage return is still there.
Any help will be greatly appreciated.