Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: multiple-line csv import
Ralf,
Depending upon the original source of the information, it may be better to
copy from one database directly into the Oracle database. Here is an example
program which makes an ODBC connection for this type of transfer:
http://www.dotcomsolutionsinc.net/products/fmpro_migrator/oracle_files/fmpro
_migrator_oracle_xfer_odbc1.html
-- David Simpson www.dotcomsolutionsinc.net "Ralf" <Threepwood.Guybrush_at_gmx.de> wrote in message news:71cfc7f.0307070656.3122f03d_at_posting.google.com...Received on Tue Jul 15 2003 - 18:09:09 CDT
> Hi,
> I try to import a CSV file to a Oracle database using the SQL*Loader.
> My problems are multiple-line text fields. Example:
>
> ID;NAME;INFO;GENDER
> 1;James;"My new butler,
> a lame guy";male
> 2;Fry;"The pizza guy,
> what a man!";male
>
>
> The control file looks like this:
>
> LOAD DATA
> INFILE 'c:\dev\import_.csv'
> APPEND
> INTO TABLE wais
> FIELDS TERMINATED BY ';'
> TRAILING NULLCOLS
> (
> ID INTEGER,
> NAME CHAR TERMINATED BY ';',
> INFO CHAR TERMINATED BY ';' ENCLOSED BY '"',
> GENDER CHAR TERMINATED BY ';'
> )
>
>
> CONTINUEIF could be the solution, but I didn't find out how to use it
> correctly.
>
> Thanx in advance.
>
> Ralf