How can I use tables from oracle in MS Access vice versa.
or how I can export data from Oracle to MS Access
Please help me :.-(
In Oracle there is a utility called Database Migration Assistant from Microsoft Access to Oracle.Run this utility and it will help to migrate ur data from Access to Oracle.
In case of any help please be free to ask me at email@example.com
Rohit Nirkhe,Oracle DBA,OCP 8i
rohitsn is right, but if you need to work on line with, say, data from oracle via an access window, update the data in access window and commit the data to the oracle database, ODBC is the way to do it. you can create the connection from access in some user friendly steps.
Can anybody tell me the exact process of copying data from
Oracle db to Access
Click Here to Expand Forum to Full Width