Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Microsoft Access or Microsoft Excel >>>>>> Oracle PRO
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