Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Microsoft Access or Microsoft Excel >>>>>> Oracle PRO

Re: Microsoft Access or Microsoft Excel >>>>>> Oracle PRO

From: Gary England <gengland_at_hiwaay.net>
Date: 1997/12/10
Message-ID: <348E7E3F.564F@hiwaay.net>#1/1

Excel can connect directly to an ORACLE ODBC driver or go through Access. The difference is in the OpenDatabase. Below are commands to connect to Access, Sybase or ORACLE from any VBA application.

'Establish connection to an Access database that links to the desired
database
Set db = OpenDatabase("C:\My Documents\TEST2.mdb")
'Connect to Sybase, Not exclusive, Read-Only
Set db = OpenDatabase("", False, True,
"ODBC;DATABASE=prod_live;UID=gengland;PWD=welcome;DSN=TEST")
'Connect to ORACLE, Not exclusive, Read-Only
Set db = OpenDatabase("", False, True,
"ODBC;UID=gengland;PWD=welcome;DSN=TEST2")

The ODBC configuration points to the appropriate drivers and database alias names. Received on Wed Dec 10 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US