Line Break Icon

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am importing a field from excel that has multiple lines within each cell
separated by a line break (Alt+Enter). When I import the data into access, a
square box icon appears at each line break rather than an actual line break
and the contents of the field read in a continuous line. Is there any
systematic way to replace these icons with actual line breaks?

Thanks.
 
aisos12 said:
I am importing a field from excel that has multiple lines within each
cell separated by a line break (Alt+Enter). When I import the data
into access, a square box icon appears at each line break rather than
an actual line break and the contents of the field read in a
continuous line. Is there any systematic way to replace these icons
with actual line breaks?
Click to expand...

Yes. After you've import the data, run an update query that replaces
the character Chr(10) -- the line-feed character, which Excel uses as a
line break -- with the character combination Chr(13) & Chr(10), which
Access uses as a line break. The SQL of such a query would be something
like this:

UPDATE YourImportedTable
SET [YourField] = Replace([YourField], Chr(10), Chr(13) & Chr(10));
 
Back
Top