Line Break Icon

[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.

 

[Dirk Goldgar]

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?

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));