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 -> HOW TO GET ROWS FROM EXCEL TO ORACLE

HOW TO GET ROWS FROM EXCEL TO ORACLE

From: Maniek <jakis_at_wp.pl>
Date: Thu, 31 Jan 2002 18:10:22 +0100
Message-ID: <a3btrt$pkp$1@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 Thu Jan 31 2002 - 11:10:22 CST

Original text of this message

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