Home » Other » General » How to access table from *.mdb? (oracle 9i)
How to access table from *.mdb? [message #334055] Tue, 15 July 2008 06:00 Go to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

Hi
I having oracle 9i and I want to access the Access database.
How to do it.

Please help me.

Thank in advance

kanish
Re: How to access table from *.mdb? [message #334063 is a reply to message #334055] Tue, 15 July 2008 06:35 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
By using Heterogeneous Services Agents with an ODBC driver for example.
Re: How to access table from *.mdb? [message #334211 is a reply to message #334063] Tue, 15 July 2008 20:09 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9100
Registered: November 2002
Location: California, USA
Senior Member
Or you can export to ascii text files and load using SQL*Loader or external tables.
Re: How to access table from *.mdb? [message #334259 is a reply to message #334055] Wed, 16 July 2008 00:30 Go to previous messageGo to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

Hi ThomasG
It is very helpful link

Suppose if having oracle 10g on windows xp

Is is suits to me.

Thanks.

kanish
Re: How to access table from *.mdb? [message #334261 is a reply to message #334259] Wed, 16 July 2008 00:34 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Check this thread; you'll find a great example presented by Maaher.
Previous Topic: connection problem
Next Topic: Home computer system requirements for Oracle 11g
Goto Forum:
  


Current Time: Fri Nov 29 16:06:28 CST 2024