Home » Developer & Programmer » Data Integration » how to import an access mdb to oracle warehouse builder
how to import an access mdb to oracle warehouse builder [message #158476] Sat, 11 February 2006 15:16 Go to next message
s8472
Messages: 15
Registered: February 2006
Junior Member
hi guys,

i need your help! i cannot figure out how to import an access file (version Access 2000) to the oracle warehouse builder.
i already used the OWB client to import a flat file to OWB and it worked perfectly, but didn't work with the mdb file.

thx in advance

greetings
s8472
Re: how to import an access mdb to oracle warehouse builder [message #158606 is a reply to message #158476] Mon, 13 February 2006 07:29 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
You need an ODBC database link.

Create a Heterogenous Service for your Access database. This is described in Metalink Note 102537.1


MHE
Re: how to import an access mdb to oracle warehouse builder [message #159003 is a reply to message #158476] Wed, 15 February 2006 07:38 Go to previous message
s8472
Messages: 15
Registered: February 2006
Junior Member
thx for the answer. i ll search for it.

greetings
s8472
Previous Topic: difference between connected / unconnected lookup
Next Topic: WB 10gR1 and Asynchronous CDC
Goto Forum:
  


Current Time: Thu Mar 28 13:12:51 CDT 2024