Oracle-L: RE: Excel's Oracle connectivity

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Mon, 11 Mar 2002 07:38:25 -0800
Message-ID: <F001.00424981.20020311073825@fatcity.com>

The scientists here like it too, they like to cut and paste blocks of data.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique 
Maritimes Region, DFO      | Région des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca

-----Original Message-----

Sent:	Monday, March 11, 2002 10:18 AM
To:	Multiple recipients of list ORACLE-L
Subject:	RE: Excel's Oracle connectivity

It's called "MS Query Add-in" and "ODBC Add-in" for Excel. The add-in modules can be installed from the CDs, if not already installed. I've played around with this for end-user reporting and found that the data refresh was extremely slow compared to SQL*Plus, SQL Navigator, etc.

Let me know if you find a way to use it successfully. Seems useful, especially for accountants who work extensively in Excel, if you can get response times you can live with.

Best,

david

David B. Wagoner
Database Administrator
Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 110
Cary, NC 27511-8582
Office (919) 466-6723
Mobile (919) 225-4962
Fax (919) 466-6783
http://www.arsenaldigital.com/

NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by phone or email and delete this e-mail message from your computer. Thank you.

-----Original Message-----

Sent: Monday, March 11, 2002 8:13 AM
To: Multiple recipients of list ORACLE-L

Hi,

some monthes back I read about a free utility that one could plugin to Excel. From then on Excel could read any data into it from Oracle. The SQL command could be written into the Excel sheets, so the user could refresh data any time he/she had Oracle connectivity and OLE connection. I forgot the link. Could some one please help me? (It was NOT Oraxcel!!)

TIA, Tamas Szecsy
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Szecsy Tamas
INET: tszecsy_at_GEOMETRIA.hu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------


To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: David Wagoner
INET: dwagoner_at_arsenaldigital.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------


To REMOVE yourself from this mailing list, send an E-Mail message

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------


To REMOVE yourself from this mailing list, send an E-Mail message