Re: HOW TO GET ROWS FROM EXCEL TO ORACLE

From: Makbo <makbo_at_pacbell.net>
Date: Sat, 09 Feb 2002 15:11:33 GMT
Message-ID: <3C653C24.5090309@pacbell.net>

Another approach is to use Perl on the same machine as your Excel file, and with DBD::Oracle and DBD::ODBC modules, you can pretty much move and massage the data any way you want. Set up the Excel file as an ODBC data source.

Drawback is the overhead of configuring Perl, Oracle client and ODBC datasource on your Windows machine, plus knowing Perl programming.

Advantages are, it's portable, scalable, and flexible in terms of using whatever source and target data source you want, such as CSV, MS SQL Server, XML, etc. And, it's easier to run something like this in unattended batch mode if necessary.

I had to do something very similar with MS Access, which involved creating a matching Oracle schema from scratch and then copying the table data.

Chuck wrote:

> I know of a couple of ways.
[...]

> 
> There may be an easier way but I'm not aware of it. It would be great if
> Excel could export to ODBC databases. 
> 
> "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?
>>[...]
>>
>>
>>
>>

>
> Received on Sat Feb 09 2002 - 09:11:33 CST