Re: Any tools to transfer files/data between Oralce & Excel

See \orawin95\oo4o21\Excel\Samples\oo4o_ora.xls and empx.xls

Accessing Oracle7 Servers Using Oracle Objects for OLE         

This Excel file demonstrates how Oracle Objects for OLE can be used to access Oracle7 Servers from the Visual Basic for Application environment. It is meant to jumpstart the developer to using the product.

DataSheet - The sheet contains query results.         

GetData - Retrieves and pastes query result to DataSheet.         

UpdateData - After editing the DataSheet, run this macro to update the Server.         

GetArray - Shows how array can be used to efficiently retrieve large amounts of Server data with one transaction.         

It performs the following steps:

1. Dim and set objects
2. Send the PL/SQL procedure on the Server. (Typically procedures will be created on the server and not sent from the client.)
3. Send parameters to the Server
4. Assign values (empno) to input parameters
5. Call the procedure which sends the entire array of empno's in one transaction and retrieves the entire array of enames.
6. Display the retrieved array to the screen.

CursorReturn - Shows how to return PL/SQL Cursors. This feature offers read-only access to cursors. It assumes you have already loaded the PL/SQL stored procedure found in

c:\orawin95\oo4o2\oraexamp.sql

1. Dim and set objects
2. Get "dept" from cell J2 on DataSheet.
3. Create dept parameter
4. Create the dynaset by invoking the stored procedure
5. Copy the dynaset to the clipboard and paste the data to DataSheet

   ---

   Regards, Halley