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

Home -> Community -> Usenet -> c.d.o.server -> Re: Is it possible to load the excel file by using external table without converting it into csv comma delimited file

Re: Is it possible to load the excel file by using external table without converting it into csv comma delimited file

From: gazzag <gareth_at_jamms.org>
Date: 11 Jul 2006 04:51:42 -0700
Message-ID: <1152618702.330465.208510@s13g2000cwa.googlegroups.com>


Khurram wrote:
> hi
>
> I am using oracle 9.2.0.1.0 version..
>
> Is it possible to load the excel file by using external table without
> converting it into csv comma delimited file??
>
> If yes then please tell me how can i achieve it
>
> I want to fileds terminated by cell for excel file.
>
>
> FIELDS TERMINATED BY <CELL>
>
> Thanx in advance
>
> Khurram

Try opening an Excel spreadsheet in a text editor and you'll get your answer.

HTH -g Received on Tue Jul 11 2006 - 06:51:42 CDT

Original text of this message

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