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

From: Jason Samsa <lysasome_at_yahoo.com>
Date: 18 Jan 2002 09:05:08 -0800
Message-ID: <18f9efe2.0201180905.bf8031@posting.google.com>

"Norris Sze" <hk1_at_hotmail.com> wrote in message news:<a28kb6$aq55_at_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 - 11:05:08 CST