Re: Problems with MS Access text export -> sqlldr -> Oracle
Date: Mon, 14 Jan 2002 02:36:53 GMT
Message-ID: <3c42440f.118751926_at_news.dt1.sdca.home.com>
On Sun, 13 Jan 2002 17:56:49 -0500, Lee <lee_at_jamtoday.com> wrote:
>
>On 9 Jan 2002 16:11:46 -0800, matt_butler_at_agilent.com (Matt Butler)
>wrote:
>
>>Sorry for the multiple cross-posts but I'm in great need of
>>assistance:
>>
>
>I have pretty much the same problem. I want to export data in a
>"legacy" Access system via "flat" files, one physical record per
>logical line. Sql loader chokes on the output because of the embedded
>CR LF.
>
>I asked the comp.database.ms-access group for advice. There were a
>number of approaches, but the concesus seems to be to create a
>function that strips CR LF (char(10) and char(13) ) from the text
>fields, then export a "view" of the original table where all text
>fields of the original table show up as replace( originial_col,
>"crlf", null) where "crlf" is expressed in VB-ish mode
>chr$(10)&chr$(13) and null is "".
>
www.ultraedit.com
UltraEdit does this.
Received on Mon Jan 14 2002 - 03:36:53 CET