散点分,顺便寻求一个方案,access库如何与oracle做数据同步。
access库在工控机上,不能随意访问。决定将access上的数据同步到oracle中,应用端访问oracle库,看看大家有啥好的方案不。
access库在工控机上,不能随意访问。决定将access上的数据同步到oracle中,应用端访问oracle库,看看大家有啥好的方案不。
解决方案 »
- 多个用户调用使用临时表的存储过程,会出问题吗
- Oracle数据库视频
- oracle中设置主键id可以像mysql sqlserver那样直接设置吗
- oracle 11g的启动
- ORACLE 10G和9i的数据DMP问题
- CSV文件里如果有换行怎么解决呀--高手请阅
- substr用法
- ##100分!!!高手,帮忙改一下这段SQL文
- 请问新装Oracle 8i后各个程序需要的用户名和口令是...?
- 一个简单的SQL Server语句如何在Oracle中实现
- 不显示删除回复显示所有回复显示星级回复显示得分回复 十分紧急的问题,紧急求助。oracle9i的left join有状况[
- oracle 数据库:删除表中的重复记录
========
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.
用.net 写个小的winform 不是很复杂,就是调用 引用oracle 和access 客户端 的命名空间而已。导入导出也简单。
方案2:
纯SQL解决办法。
我不知道怎么用ORACLE 直接访问ACCESS。但是我可以做到。ORACLE 访问SQLSERVER ,SQLSERVER 访问ACCESS。这也可以解决。就是比较麻烦。
多谢费心。这是access链接oracle的方案,我想让oracle去链接access,因为access文件不让随便动。