Access 97 remove line breaks
Hello! I have old mdb base with invisible line break. After export to excel i got new lines - and it brokes data structure.
How can i remove line breaks from datatable?
UPDATE table1 SET attr1 = trim(attr1) dont help.
UPDATE table1 SET attr1 = replace([attr1 ], chr(10), " ") not working - replace function not exist in access 97.