Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to insert oracle table data into MS access table?

Kam__apexNov 15 2016 — edited Nov 28 2016

Dear Friends

I am working on oracle11g XE. I want to insert the oracle table data into MS access (mdb) file. How can i do this?

Please help i will be thankful.

I did it through the link www.orafaq.com/node/60

in the end when i run below query

SELECT * FROM my_access_tab@access_db;

it gives below error

ORA-28545: error diagnosed Net8 when conneccting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: 2 lines from access_db

please help

Regards

Kamran

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 26 2016

Added on Nov 15 2016

#heterogeneous-connectivity

20 comments

9,335 views