Re: sqlloader

From: John F. Keaveney <johnkeaveney_at_targusinfo.com>
Date: Tue, 26 Oct 1999 14:06:32 -0700
Message-ID: <7v55ft$nom$1@ffx2nh3.news.uu.net>

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