Converting the little squares to returns

  • Thread starter Thread starter Bryce Dalley
  • Start date Start date
B

Bryce Dalley

I'm importing data from MS Excel. In the Excel format
there are several alt enters (To space down in one cell).
However, when I bring this over to Access, they turn into
little squares. Is there a query I could write that can
replace this with an "enter". I think access uses cntrl
enter to space this way.

I'm using Access 2002, and would appreciate any advice.
 
For Access 2002:
Do you want to keep the line space?
If I remember correctly, Excel uses just the line feed character (chr(10)).

Try this on a backed-up table:
Update YourTable Set YourTable.FieldName =
Replace([FieldName],chr(10),chr(13) & chr(10))
 
Back
Top