Re: HOW TO GET ROWS FROM EXCEL TO ORACLE

From: Bryan W. Taylor <bryan_w_taylor_at_yahoo.com>
Date: 8 Feb 2002 19:09:45 -0800
Message-ID: <11d78c87.0202081909.28b09dd9@posting.google.com>

"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've used each of these three methods at some point:

Save to tab delimited format and use sql*loader
link your excel table and your oracle table into Access using odbc and write an insert query to move data from one to the other.
Construct an excel formula to dynamically build the insert statement string out of the other columns, then copy it down and cut and paste the result into a script

The first method loads the data the fastest. The second method is probably easiest for people who are scared of SQL. The third method always works (doesn't depend on having sql*loader or Access installed) and can be done "offline" to create pure SQL. Received on Fri Feb 08 2002 - 21:09:45 CST