Re: Oracle Connect to Excel

From: Peter Chong <pchq45_at_hotmail.com>
Date: 14 Sep 2001 13:20:20 -0700
Message-ID: <444b2a14.0109141220.2d7c99ec_at_posting.google.com>

gmohata_at_yahoo.com (Girish Mohata) wrote in message news:<42a840c2.0109071857.975aab5_at_posting.google.com>...
> Hi All,
> I want to query a Oracle Table and want the results to be shown on an
> Excel sheet. If any changes are made to the Excel sheet, they should
> be allowed to be written back to the Database.
> I have an idea this can be done using Excel Macros, but dont know
> anything further.
> Please Help.
>
> Girish

What I know in VB, you could connect Oracle via ODBC and add excel object in
VB reference and you could read and Oracle to populate Excel work sheet or
Read an Excel work sheet row and column and compose a SQL command (Inset or Update) string base on logic.

Peter Chong
Sr. ERP Analyst VB/Oracle. Received on Fri Sep 14 2001 - 22:20:20 CEST

This message: [ Message body ]
Next message: Reid Lai: "Re: Is it better to drop a rollback segment and recreate it instead of add additional rollback segment?"
Previous message: waltervdv: "Re: Automatic Firing of Procedure/Trigger"
In reply to: Girish Mohata: "Oracle Connect to Excel"
In reply to Girish Mohata: "Oracle Connect to Excel"
Next in thread: Reid Lai: "Re: Is it better to drop a rollback segment and recreate it instead of add additional rollback segment?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message