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: Loading data into oracle tables from .xls files

Re: Loading data into oracle tables from .xls files

From: Gregory Conron <gconron_at_hfx.andara.com>
Date: Thu, 30 Nov 2000 07:30:39 -0400
Message-Id: <10696.123306@fatcity.com>


On Thu, 30 Nov 2000, you wrote:
> Dear DBA gurus,
>
> I have some data in Excel sheet which is in xls format which I have to
> load into Oracle tables. How do I do it? Any help in this regard will be
> highly appreciated.
>
> TIA and regards,

You can dump the data into a comma delimited file and load it using sqlloader.

Cheers,
GC

-- 
"The opposite of a correct statement is a false statement. But the opposite 
of a profound truth may well be another profound truth." 
                                    --Niels Bohr
Received on Thu Nov 30 2000 - 05:30:39 CST

Original text of this message

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