Remove carriage returns in memo fields

[judith]

I have imported some data from Excel where the Alt+ Enter has been used to
line space information in a cell. This comes over as | type character. Any
suggestion please as to how I can relace these characters with a carriage
return in the imported memo field.

Thanks

 

[Stefan Hoffmann]

I have imported some data from Excel where the Alt+ Enter has been used to
line space information in a cell. This comes over as | type character. Any
suggestion please as to how I can relace these characters with a carriage
return in the imported memo field.

Run an UPDATE query like this:

UPDATE [yourTable]
SET [yourMemoField] = Replace([yourMemoField],
Chr(10),
Chr(13) & Chr(10))

imho Excel only uses the Lf character:

Chr(10) is Lf
Chr(13) & Chr(10) is CrLf

be sure, that you have a backup copy of your table/database before
trying it.

mfG
--> stefan <--