Problems with display of concatenated data in Access report sourced from Excel (1 Viewer)

[reglarh]

I am extracting data into Access from an external system where the data is presented in an Excel spreadsheet.

One column holds a name in text format, but very occasionally there are two names (don't ask!). In the external spreadsheet the names appear as two lines but when used in an Access report the two names are concatenated with no space between. If I copy the concatenated names from the Access table and post into a new spreadsheet the names once again appear on two lines.

There appears to be a hidden 'new line' character in the data which the Access report ignores. How do I get Access to use it?

 

[CJ_London]

pretty sure newline in Excel is just chr(10) (or might be chr(13)) whereas in Access it is chr(10) & chr(13) (vbCrLf)

so try using the replace function when importing

replace(mytext,chr(10), chr(10) & chr(13))

 

[nomini]

ы