Gossamer Forum
Home : General : Databases and SQL :

Delete Carriage return query

Quote Reply
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: OPTILU2008TU

I have tried to simply search for UniCode Alt+0129, but no good.

Smile
Subject Author Views Date
Thread Delete Carriage return query Mad_Mick 79963 Jan 18, 2004, 7:10 PM
Thread Re: [Mad_Mick] Delete Carriage return query
Andy 79689 Jan 19, 2004, 2:48 AM
Post Re: [Andy] Delete Carriage return query
Mad_Mick 79480 Jan 19, 2004, 2:45 PM
Thread Re: [Mad_Mick] Delete Carriage return query
llccoo 79506 Jan 25, 2004, 9:23 AM
Thread Re: [llccoo] Delete Carriage return query
Mad_Mick 79559 Jan 26, 2004, 1:52 PM
Post Re: [Mad_Mick] Delete Carriage return query
Watts 79474 Jan 26, 2004, 3:36 PM
Thread Re: [Mad_Mick] Delete Carriage return query
llccoo 79436 Jan 26, 2004, 3:43 PM
Thread Re: [llccoo] Delete Carriage return query
Mad_Mick 79437 Jan 26, 2004, 4:34 PM
Post Re: [Mad_Mick] Delete Carriage return query
llccoo 79428 Jan 27, 2004, 4:17 AM
Thread Re: [Mad_Mick] Delete Carriage return query
Watts 79429 Jan 28, 2004, 9:39 AM
Post Re: [Watts] Delete Carriage return query
llccoo 79450 Jan 28, 2004, 8:45 PM
Thread Re: [Mad_Mick] Delete Carriage return query
KarlS 75938 Jul 8, 2005, 11:49 AM
Thread Re: [KarlS] Delete Carriage return query
BI 75727 Jul 26, 2005, 3:17 AM
Post Re: [BI] Delete Carriage return query
theryall 57430 Nov 13, 2007, 1:16 AM
Thread Re: [Mad_Mick] Delete Carriage return query
justin.kearney 55224 Feb 29, 2008, 7:01 AM
Thread Re: [justin.kearney] Delete Carriage return query
LaLa 52581 Jun 24, 2008, 4:47 PM
Post Re: [LaLa] Delete Carriage return query
justin.kearney 52485 Jun 25, 2008, 5:37 AM