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?
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?