Re: Using SQL Loader to import data with carriage return

From: Philippe Arnaud <parnau_at_ctp.com>
Date: 24 Jul 1998 06:32:48 GMT
Message-ID: <01bdb6cc$7093cd00$2a822c95_at_pdcpm>


With Access you can directly export to Oracle (you need ODBC)

Lisa Soong <lisa_at_kkipcom.com.sabah.net.my> wrote in article <35B6A72A.5D776A34_at_kkipcom.com.sabah.net.my>...
> Hi all,
>
> I am a newbie to Oracle and I am trying to import data from an Access
> database into my Oracle database by first extracting the Access data
> into a flat fixed length file (text) and then using SQL Loader ver8.0 to
> load that flat file into my Oracle database. However some of the
> address fields in MSAccess has carriage returns and when I export that
> into a flat file, SQL loader assumes that it is a new record and
> everything from there onwards get messed up! Is there anyway I can get
> SQL Loader to ignore the carriage return and to just judge record length
> from positions as set in the SQL Loader control file?
>
> --
> Best Regards,
> Lisa
> lisa_at_kkipcom.com.sabah.net.my
> KKIP Communications Sdn Bhd
>
>
>
Received on Fri Jul 24 1998 - 08:32:48 CEST

Original text of this message