OraFAQ Forum: Windows » Connect Microsoft Access Database with Oracle 9i Database

Home » Infrastructure » Windows » Connect Microsoft Access Database with Oracle 9i Database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connect Microsoft Access Database with Oracle 9i Database [message #394407]

Thu, 26 March 2009 19:34

skkazmi
Messages: 44
Registered: April 2006

Member

Hi All,

I am facing a problem regarding connectivity with microsoft access with oracle 9i database. Is their any posibility to connect mdb file with oracle 9i database.

If anyone have the solution regarding please reply.

Thanks,
Best Regards,
Kazmi

Report message to a moderator

Re: Connect Microsoft Access Database with Oracle 9i Database [message #394408 is a reply to message #394407]

Thu, 26 March 2009 19:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Is their any posibility to connect mdb file with oracle 9i database.
No.

Did you read & follow the bouncing RED ball advice as stated in URL below?
http://www.orafaq.com/forum/f/32/136107/
Did you read & follow Posting Guidelines as contained in URL below?
http://www.orafaq.com/forum/t/88153/0/

You need to use Access to open the *mdb file & dump the results to a text file which can then be loaded into Oracle.

Report message to a moderator

Re: Connect Microsoft Access Database with Oracle 9i Database [message #394409 is a reply to message #394408]

Thu, 26 March 2009 19:57

skkazmi
Messages: 44
Registered: April 2006

Member

Thanks for your reply.

Is their any posibility to connect *.mdb file with ODBC connection then this connection will communicate with oracle.

I need to design an application in oracle developer which insert record from *.mdb file into oracle database and after insertion from *.mdb file the data will be removed from the file.

Best regards,
Kazmi

Report message to a moderator

Re: Connect Microsoft Access Database with Oracle 9i Database [message #394410 is a reply to message #394407]

Thu, 26 March 2009 20:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I need to design an application in oracle developer
When your only tool is a hammer, all problems are viewed as nails.
A hammer is a great tool, but only in some cases.
A hammer would be a less than optimal for the task of making 2 boards from 1 board.
You may have the wrong tool to accomplish your goal.

I know the desired task could be done with some custom PERL code.

I could be mistaken, but I do not think that an Oracle Developer application can manipulate data within a *MDB file.

Report message to a moderator

Re: Connect Microsoft Access Database with Oracle 9i Database [message #394437 is a reply to message #394409]

Fri, 27 March 2009 01:52

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Well, you might search the board (keywords: access, odbc). One of useful discussions might be this one which contains a great example provided by Maarten. Check whether it helps; if not, expand your search and/or revert back with new question(s).

Report message to a moderator

Previous Topic:	Which one to install at first ?
Next Topic:	Setting datestamp on export file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 14:36:29 CDT 2025