Re: Import and Export between Excel and Oracle using PL/SQL
From: Gerrit-Jan Linker <gjlinker_at_oraxcel.com>
Date: Fri, 22 Feb 2002 11:22:25 +0000 (UTC)
Message-ID: <a559lh$t1f$1_at_knossos.btinternet.com>
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.
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.
Date: Fri, 22 Feb 2002 11:22:25 +0000 (UTC)
Message-ID: <a559lh$t1f$1_at_knossos.btinternet.com>
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 - 12:22:25 CET