Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Loader and csv files
Its a while since I used sql loader but did you know you can use functions
in the control? You can use decode to replace your commas with tabs. Best is
to use the golden product set (shareware http://www.benthicsoftware.com).
Mark has an excellent importer that supports a variety of delimiters. Also
if you have MS Access you can set up a link table and just paste in rows
which is easiest for small tables.
Don
Mike Roca, Jr. <roca_at_ultranet.com> wrote in message
news:382C7B1A.31BC528C_at_ultranet.com...
> Hi,
>
> I'm attempting to get SQL*Loader to transfer a csv file into an Oracle
> database, however, I seem to be running into a bit of a problem.
>
> I tried the following command:
> sqlldr LOG=check.log, DATA=nscp.csv, USERID=vlad/math, CONTROL=nscp.ctl
>
> Here's ctl file:
> LOAD DATA
> INFILE 'nscp.csv'
> INTO TABLE nscp
> (dat date "MM/DD/YY",
> cola float external,
> colb float external,
> colc float external,
> cold float external,
> larg integer external)
>
> The CSV file that I am trying to load into Oracle contains over 200 rows
> similar to the following:
> 1/12/99,64.500,71.500,64.000,71.063,6625200
> 1/11/99,68.938,70.500,64.500,64.500,6818800
> 1/8/99,61.938,65.563,61.875,64.750,4272300
>
> I'd concider using the position keyword, but the variables are separated
> by commas rather than tabs, so the positioning is different for every
> row.
>
> -Mike
Received on Sun Nov 14 1999 - 16:14:41 CST