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_at_posting.google.com>
Date: 18 Jan 2002 09:05:08 -0800
Message-ID: <18f9efe2.0201180905.bf8031_at_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 - 18:05:08 CET