Export data from Oracle to Access

[abdali]

hi guys,

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 :.-(

[shawish_sababa]

Hi

use odbc.

[rohitsn]

Hi,
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 rohitsn@altavista.com


Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
rohitsn@altavista.com

[shawish_sababa]

Hi

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.

[pareshg]

Hi all

Can anybody tell me the exact process of copying data from
Oracle db to Access

Thanks
Paresh