0 pts.
 Oracle / ccess
How does one setup a link between oracle and acess database. I have been able to setup it up from acess to oracle using ODBC

Software/Hardware used:
ASKED: August 31, 2005  8:31 AM
UPDATED: August 31, 2005  1:15 PM

Answer Wiki:
No way I'm aware of to directly access MS Access from Oracle. Oracle has the OMWB (Migration Workbench) utility which will help to convert MS Access to Oracle. http://www.oracle.com/technology/oramag/oracle/02-may/o32tools.html Could also use SQL Loader utility or read as External table (9i) after saving MS Access data as delimited text. Also saw this utility that moves MS Access databases to Oracle. http://www.topshareware.com/Access-to-Oracle-download-17598.htm
Last Wiki Answer Submitted:  August 31, 2005  1:15 pm  by  Kurthp   195 pts.
All Answer Wiki Contributors:  Kurthp   195 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _