Purpose:
========
How to link Microsoft Access to Oracle RDBMS using an ODBC Driver.
Scope & Application:
====================
This article provides an easy and effective way to modify data within
an Oracle RDBMS database using Microsoft Access V7 (Office 95) or
V8 (office 97).
Assumptions:
- You are using Microsoft Office 95 or Office 97 Access.
- Your Oracle RDBMS database is V7.3 or higher.
- You use the Microsoft Windows NT operating system.
Steps:
1. Launch Access and open/create the database.
2. On the File menu, select "Get External Data", then select the "Link
Tables..." option.
3. In the "Link" dialog box click on the drop-down menu for "Files of
Type" and select "ODBC Databases()" from the list.
4. If you have previously created a data source using ODBC, select
it and skip to step 10.
5. In the "Select Data Source" dialog box, select "Machine Data Source",
tab, then click on the "New..." button.
6. In the "Create New Data Source" dialog box, select "User Data
Source (applies to this machine only)", then press "Next."
7. On the next page of the "Create New Data Source" dialog box, select
"Oracle73 Ver 2.5" from the list and click the "Next" button.
8. On the final page of the "Create New Data Source" dialog box, review
the driver selection and click the "Finish" button.
9. In the "Oracle7 ODBC Setup" dialog box, fill in the following fields:
A. Data Source Name - This is a name you use to identify the
data source. For example, "Call Routing."
B. Description - A description of the data in the data source.
For example, "Access to all objects in Call Routing Tablespace."
C. SQL*Net Connect String - An Oracle connect string specifies
the location of Oracle RDBMS from which the driver
retrieves data. To connect to a local installation of Oracle,
use "2:" to indicate that the driver should connect to the
local instance. To connect to a remote Oracle server, use
a SQL*Net V2 connect string. For example, use "2:ORCL"
(note: this does not work with Oracle 8) for a local connection.
Use the alias name "ORCL" for a remote connection.
Click the "OK" button.
10. In the "Select Data Source" dialog box, select the previously created data
source and click the "OK" button.
11. In the "Logon to Oracle" dialog box, enter the "User Name," "Password,"
and "Service", then click the "OK" button.
12. From "Link Tables", select the table(s) you wish to link to
Microsoft Access.
This completes the linking of Microsoft Access to Oracle using
an ODBC Driver.
[Quote=引用 10 楼 liuyi8903 的回复:]
我没有做过access to oracle方面的方案,更不用说同步.
我帖一下关于两个的连接的方案吧,来自metalink note:70668.1
Purpose:
========
How to link Microsoft Access to Oracle RDBMS using an ODBC Driver.
Scope & Application:
====================
This article provides an easy and effective way to modify data within
an Oracle RDBMS database using Microsoft Access V7 (Office 95) or
V8 (office 97).
Assumptions:
- You are using Microsoft Office 95 or Office 97 Access.
- Your Oracle RDBMS database is V7.3 or higher.
- You use the Microsoft Windows NT operating system.
Steps:
1. Launch Access and open/create the database.
2. On the File menu, select "Get External Data", then select the "Link
Tables..." option.
3. In the "Link" dialog box click on the drop-down menu for "Files of
Type" and select "ODBC Databases()" from the list.
4. If you have previously created a data source using ODBC, select
it and skip to step 10.
5. In the "Select Data Source" dialog box, select "Machine Data Source",
tab, then click on the "New..." button.
6. In the "Create New Data Source" dialog box, select "User Data
Source (applies to this machine only)", then press "Next."
7. On the next page of the "Create New Data Source" dialog box, select
"Oracle73 Ver 2.5" from the list and click the "Next" button.
8. On the final page of the "Create New Data Source" dialog box, review
the driver selection and click the "Finish" button.
9. In the "Oracle7 ODBC Setup" dialog box, fill in the following fields:
A. Data Source Name - This is a name you use to identify the
data source. For example, "Call Routing."
B. Description - A description of the data in the data source.
For example, "Access to all objects in Call Routing Tablespace."
C. SQL*Net Connect String - An Oracle connect string specifies
the location of Oracle RDBMS from which the driver
retrieves data. To connect to a local installation of Oracle,
use "2:" to indicate that the driver should connect to the
local instance. To connect to a remote Oracle server, use
a SQL*Net V2 connect string. For example, use "2:ORCL"
(note: this does not work with Oracle 8) for a local connection.
Use the alias name "ORCL" for a remote connection.
Click the "OK" button.
10. In the "Select Data Source" dialog box, select the previously created data
source and click the "OK" button.
11. In the "Logon to Oracle" dialog box, enter the "User Name," "Password,"
and "Service", then click the "OK" button.
12. From "Link Tables", select the table(s) you wish to link to
Microsoft Access.
This completes the linking of Microsoft Access to Oracle using
an ODBC Driver.