Query to update a column in access database.
Budget: $10 – $30 USD
Hello all,
I have an access database where I import data from an excel sheet to a column. The access column is a long text datatype. The excel sheet cells have multiple "Shift + Enter" which cause the following string to be appended '_x000d_'.
Can some write a query which would replace "Shift + Enter" to simply "Enter" or any other way to correct this issue.
I have an access database where I import data from an excel sheet to a column. The access column is a long text datatype. The excel sheet cells have multiple "Shift + Enter" which cause the following string to be appended '_x000d_'.
Can some write a query which would replace "Shift + Enter" to simply "Enter" or any other way to correct this issue.