excel carriage returns as squares

[goan]

When I import an Excel table into Access 2007 all carriage returns appear as
small squares. How do I get rid of the squares and retain the formatting in
the memo fields?
Since I am not a programmer I would appreciate step by step instructions.
Thanks.

 

[Clifford Bass]

Hi,

That is because the "carriage return" (CR) in access is really just a
line feed (LF) and Access uses a CR/LF sequence. Try something like this:

UPDATE tblImportedMemo
SET TheMemo = Replace([TheMemo],Chr(10),Chr(13) & Chr(10))
WHERE InStr([TheMemo],Chr(10))>0 AND InStr([TheMemo],Chr(13))=0;

This will only change the LFs to CRLF if there are LFs, but not CRs.
So you can run it on the table mutliple times without messing up older
records that have already been fixed.

Clifford Bass