Re: HOW TO GET ROWS FROM EXCEL TO ORACLE

From: Gerrit-Jan Linker <gjlinker_at_oraxcel.com>
Date: Sat, 23 Feb 2002 22:03:36 +0000 (UTC)
Message-ID: <a593jn$611$1@paris.btinternet.com>

Hi,

I've already posted an elaborate reply to one of the other newsgroups to which this message was cross posted. Basically it reads that you can use SQL*XL to do this. SQL*XL has a function called OraGetColumnValue which you can type into a cell to get and value from Oracle displayed in the cell.

Have a look at SQL*XL at www.oraxcel.com

Gerrit-Jan Linker

Maniek <jakis_at_wp.pl> wrote in message news:a3btrt$pkp$1_at_news.tpi.pl...
> Hi,
>
> Id' like to get some rows from Excel file (file_name.xls) to PL/SQL
> (Developer)(Oracle).
>
> How Can I do it?
>
> i:=ORDExcel.OpenExcelWorkSheet('');
>
> orderExcel ---- does not work!!!!!, Oracle does not see !!
>
> ordcom ---- does not work!!!!!, Oracle does not see !!
> i:=ORDExcel.InsertData('A1', 'EmpNo', 'BSTR'); ---- does not work!!!!!,
> Oracle does not see !!
>
> Thanks very very much...
>
> Mariusz (Poland)
>
>
>
>
Received on Sat Feb 23 2002 - 16:03:36 CST