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: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Tue, 11 Jul 2006 12:57:05 GMT
Message-Id: <pan.2006.07.11.12.56.57.550782@sbcglobal.net> 





On Tue, 11 Jul 2006 04:09:46 -0700, 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





You can load it into database by using Spreadsheet::ParseExcel, available
for free from CPAN.


-- 
http://www.mgogala.com


Received on Tue Jul 11 2006 - 07:57:05 CDT












Original text of this message













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