Re: HOW TO GET ROWS FROM EXCEL TO ORACLE

I know of a couple of ways.

1. MSAccess. Copy and paste rows from excel to an an access table that is linked to an oracle table.
2. Save excel rows as tab delimited and use sqlloader to load them in.

There may be an easier way but I'm not aware of it. It would be great if Excel could export to ODBC databases. BTW what are ORDExcel, orderExcel, and ordcom? Are they part of 9i? (We haven't looked at 9i yet).

"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 Thu Jan 31 2002 - 11:32:10 CST