Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlloader
Save your EXCEL document as a .csv.
Create a table MYTAB which matches column for column your
Excel doc.
Then use a SQL*Loader control file like:
LOAD DATA
INFILE *
APPEND
INTO TABLE MYTAB
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
(
COL1,
COL2,
. . .
<sasubram_at_cisco.com> wrote in message news:7v4mkr$9mm$1_at_nnrp1.deja.com...
> ello everyone,
> is there a way to load the data from xcel spread sheet to oracle
> database using sql*loader.
> does it have to be in txt format?
>
> and also, is there any command in sql*loader to skip certain line?
> thanx
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Oct 26 1999 - 16:06:32 CDT