如何将数据从Oracle复制到Access表(数据还包括附件) [英] How to copy data from Oracle to Access table(Data includes attachment also)
问题描述
项目要求:与Oracle连接:通过Microsoft Access和Excel访问Oracle。
1.连接到Oracle数据库。
2.执行查询以获取包含附件(pdf,doc,word)的数据。
3.将查询结果插入Access数据库表并显示它。
i我正在使用VS 2012,C#.net为此。
i我能够访问使用ODBC的数据,但我的观点是,我如何获取并显示我的表中列出的附件数据说tbl_H2H_log。
我在想同样的事情;创建两个OLEDB
连接,每个连接一个用于Oracle数据库和Access数据库。针对Oracle数据库运行查询以检索数据,该数据将在Recordset
中找到。然后,在Access连接上打开附加查询,从Oracle数据库返回的那个中填写Recordset
,然后执行查询。 / BLOCKQUOTE>
project requirement : Connecting with Oracle: Accessing Oracle via microsoft Access and Excel.
1.Connect to an Oracle database.
2.Execute a query to fetch the data which contains attachment(pdf, doc,word) also.
3.Insert the query result into an Access database table and display it.
i am using VS 2012, C# .net for this.
i am able to access the data using ODBC but my point is that how can i fetch and show the data of attachment listed in my table say tbl_H2H_log.解决方案I was thinking the same thing; create twoOLEDB
connections, one each for the Oracle data base and the Access data base. Run your query against the Oracle data base to retrieve the data, which comes to you in aRecordset
. Then, open an Append query on the Access connection, fill itsRecordset
from the one returned by the Oracle data base, and execute the query.
这篇关于如何将数据从Oracle复制到Access表(数据还包括附件)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!