I'm trying to make a report in access derived from data I have in excel. So I import my excel sheet in access using the external data options, but my newlines keep appearing as "_x000D_"
As a example I use a excel sheet with 4 columns all with a title and all with 1 row of data containing in order from left to right:
="a"&char(10)&"b"
="a"&char(13)&"b"
="a"&char(10)&char(13)&"b"
="a"&char(13)&char(10)&"b"
In my excel sheet I have tried changing the newlines to everything I could think of but the two that appeared to have done something are char(10) and char(13) however char(10) doesn't appear in access at all and char(13) appears to become "_x000D_"