You can achieve this using SQL*XL: http://www.oraxcel.com
Export in an Excel sheet:
This is very easy to do. Open Excel and create a blank worksheet. Open the
SQL*XL query dialog and type the query that brings the data back you wish to
store in the sheet. Then sit back while SQL*XL fetches all the data into the
sheet.
You can automate all this if required. You can get it to a point where you
open a spreadsheet which automatically connects to the database, executes
the query and saves the spreadsheet. Let me know if you need an explicit
example.
Import Excel sheet:
You can open the sheet in Excel and use SQL*XL's bulk insert feature. It
takes you a few clicks and the data flows to the database. If you need to
call PL/SQL for each row then you can create anonymous PL/SQL blocks to do
this. If you need an explicit example let me know. I've answered a questions
on the newsgroups about this before so you could also look this up.
Hope this helps,
Gerrit-Jan Linker
Received on Fri Feb 22 2002 - 05:22:25 CST