[AccessD] Import Large delimited file with special character s

Thanks Drew,

....but the issue would be 'How do you tell the right from the wrong?

Thanks,

Mark


>From: DWUTKA at marlow.com
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: accessd at databaseadvisors.com
>Subject: Re: [AccessD] Import Large delimited file with special character	s
>Date: Tue, 18 Jul 2006 16:09:36 -0500
>
>The Replace() function??
>
>Drew
>
>-----Original Message-----
>From: Mark A Matte [mailto:markamatte at hotmail.com]
>Sent: Tuesday, July 18, 2006 3:59 PM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Import Large delimited file with special characters
>
>Hello All,
>
>I've been back and forth with this issue.  I think some here helped me with
>this years ago.  Importing a large delimited text file...that has a
>text/memo/blob field.  I'm running into CR or LF in the blob.  Is there a
>way to remove these characters...I seem to remember someone telling a way 
>to
>
>loop through and replace these characters...but I can't find it.
>
>Any have ideas?
>
>Thanks,
>
>Mark
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com