Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: how to load data from Excel sheet into Oracle tables using SQL*LOADER

Re: how to load data from Excel sheet into Oracle tables using SQL*LOADER

From: stephen booth <stephenbooth.uk_at_gmail.com>
Date: Wed, 17 May 2006 15:22:43 +0100
Message-ID: <687bf9c40605170722k1c4738ecwde1ac88b9fbdcb69@mail.gmail.com>


On 17/05/06, vikram singh <vikramsingh120_at_gmail.com> wrote:
>
> Hi All,
> Is there a way to load data from an Excel sheet into an Oracle table using
> SQL*Loader? I know there must be.
> Please, can anyone help me out how this can be achieved. Thanks in advance.

So far as I am aware, not directly. You can, however, save your spreadhseet from Excel as a CSV (Character Separated Variable) file which SQL*Loader can load.

Stephen

-- 
It's better to ask a silly question than to make a silly assumption.

http://stephensorablog.blogspot.com/

 'nohup cd /; rm -rf * > /dev/null 2>&1 &'
--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 17 2006 - 09:22:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US