Delete Carriage return query
Hi all, First time post, hope someone can help.
I have had to develop a contact database for about 10-15 users that currently have approx 2000 - 3000 contacts each.
I have built an Access DB and imported some of the existing data, but the original format of data that I need to import is Excel and when imported into the Access 97 table, it retains the carriage returns (from Excel) and represents them as a square (In the Access table). I need to replace the carriage return with a comma or a space. Is there any way that I can make a query that will remove or replace a carriage return??
Sample data: OPTILU2008TU
I have tried to simply search for UniCode Alt+0129, but no good.
I have had to develop a contact database for about 10-15 users that currently have approx 2000 - 3000 contacts each.
I have built an Access DB and imported some of the existing data, but the original format of data that I need to import is Excel and when imported into the Access 97 table, it retains the carriage returns (from Excel) and represents them as a square (In the Access table). I need to replace the carriage return with a comma or a space. Is there any way that I can make a query that will remove or replace a carriage return??
Sample data: OPTILU2008TU
I have tried to simply search for UniCode Alt+0129, but no good.
Delete Carriage return query