excel carriage returns as squares

  • Thread starter Thread starter goan
  • Start date Start date
G

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.
 
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
 
Back
Top