Re: Import and Export between Excel and Oracle using PL/SQL

And another possibility, if you have the data in Excel, is to just do a SAVE AS in CSV format.

Seems a lot less troublesome and complicated to me.

Daniel Morgan

Jason Samsa wrote:

> "Norris Sze" <hk1_at_hotmail.com> wrote in message news:<a28kb6$aq55@imsp212.netvigator.com>...
> > Anyone knows any helpful site or method for import and export Excel file
> > using PL/SQL. Thanks!
>
> I recently completed a project with perl DBI and
> Spreadsheet::WriteExcel. If you know perl this could be the way to
> go. Perl's DBI works great with PL/SQL and their are a pleathora of
> Excel perl modules. Go to http://search.cpan.org and search for
> excel, you'll find many tools.
>
> Another possibility is to use Excel's Data/Get External Data feature,
> but I don't think you will be able to use PL/SQL with that.
>
> HTH
>
> Jason Samsa
Received on Fri Jan 18 2002 - 12:31:45 CET