Re: New line in field

From: Mo (m.a.joomun_at_qmul.ac.uk)
Date: 03/29/04 

Date: Mon, 29 Mar 2004 13:41:42 +0100

Thanks very much for your prompt reply. Access help doesn't list an example
of the syntax of the 'Peplace' function. Can you possibly provide one?

"Van T. Dinh" <VanThien.Dinh@discussions.microsoft.com> wrote in message
news:exc8nZYFEHA.2408@TK2MSFTNGP10.phx.gbl...
> If you are using A2K or later, you can use the Replace() function in an
> Update Query to replace the NewLine + CarriageReturn with a marker that
> doesn't affect your import.
>
> If you are using A2K, there is a bug with Replace in Query and you will
need
> to write a "wrapper" function.
>
> OTOH, you may be able to export from Access (or import ) to the other
> database format without going through the intermediate Text-file step.
>

Loading