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: Excel to Oracle insert tool ?

Re: Excel to Oracle insert tool ?

From: Larry Holder <lholder_at_utm.edu>
Date: Sat, 29 Jul 2000 10:16:46 -0500
Message-Id: <10573.113309@fatcity.com>


Export from Excel, creating a text file ("flat file") then use Oracle's sqlload utility to interpret and load the file. Sqlload can handle both positional and delimited data.

Larry Holder
The University of Tennessee at Martin
lholder_at_utm.edu

At 09:54 PM 7/28/00 -0800, you wrote:
>Dear List,
>I have lots of excel data which I want to insert into
>the database oracle 8.0.5 (windows/linux) does any
>shareware/tool available.Any link will be appriciated.
>Thanks in advance.
Received on Sat Jul 29 2000 - 10:16:46 CDT

Original text of this message

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