Yeeeees. I found utility.mda for windows xp on internet, copy it to office/1033/utility.mda and UPDATE table1 SET attr1 = replace([attr1 ], chr(10), " ") works!
Yes. The same error. Undefined function left $ in expression. I google it and find some material about utility.mda - in my vb -> tools -> references -> utility.mda is missing. Maby it matter?
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 -...