Linking Microsoft Access database to Oracle 8i

[Vennie]

I created a database in Microsoft Acces 2000 and now I want to link it to ORACLE 8i.


What is the procedue to link this database to OrACLE 8i?

I need this urgently if u could please help me.

Thanks

Vennie

 

[ThomVF]

You can use ODBC or OLE-DB.

You will need to install the ORACLE Net8 client software on your PC.

For ODBC, create an ODBC DSN using the ORACLE ODBC driver.

Here are a couple of threads that discuss this.

thread181-175373
thread181-140244

Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com

 

[Turkbear]

Hi,
The 'linking' is one-way ( Access can have tables that are actually Oracle tables ) I believe..
To create the tables you have in Access in Oracle
use the export option of the file menu..
A few caveats:
Make sure all Oracle naming restrictions are followed
( no spaces or special characters in the table of field name, except an _ if desired)
Use UPPER CASE for the table and field names, it makes it easier to work with in SqlPlus and other Oracle tools.
Watch out for MEMO field conversion - if possible change them in Access to text fields..

( The better way to get Access tables into Oracle is to use the Oracle Migration Utility - it handles all that stuff for you )