Home » RDBMS Server » Server Utilities » How to load data in oracle from Microsoft Access Database (.mdb) file. (Oracle 11g R2)
How to load data in oracle from Microsoft Access Database (.mdb) file. [message #564475] Fri, 24 August 2012 04:00 Go to next message
chintan.patel
Messages: 131
Registered: July 2008
Location: Ahmedabad
Senior Member
Hi Friends

I have one .mdb (Microsoft Access Database) file and it has some tables in it. I had load it once using toad. But now i have to load it frequently into the database. Is it possible using external table, so i can access that tables using "select" statement.
If anybody knows the way, please suggest me.

Regards
Chintan
Re: How to load data in oracle from Microsoft Access Database (.mdb) file. [message #564479 is a reply to message #564475] Fri, 24 August 2012 04:11 Go to previous messageGo to next message
Michel Cadot
Messages: 58958
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No way.
Convert the .mdb to a set of csv files, then you can use SQL*Loader or external tables to load them.

Regards
Michel
Re: How to load data in oracle from Microsoft Access Database (.mdb) file. [message #564480 is a reply to message #564479] Fri, 24 August 2012 04:14 Go to previous messageGo to next message
chintan.patel
Messages: 131
Registered: July 2008
Location: Ahmedabad
Senior Member
Is there any other way to read .mdb from oracle database.

Regards
Chintan
Re: How to load data in oracle from Microsoft Access Database (.mdb) file. [message #564481 is a reply to message #564480] Fri, 24 August 2012 04:41 Go to previous messageGo to next message
Michel Cadot
Messages: 58958
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel
Re: How to load data in oracle from Microsoft Access Database (.mdb) file. [message #564483 is a reply to message #564481] Fri, 24 August 2012 05:02 Go to previous messageGo to next message
chintan.patel
Messages: 131
Registered: July 2008
Location: Ahmedabad
Senior Member
Ok

Thanks
Chintan
Re: How to load data in oracle from Microsoft Access Database (.mdb) file. [message #564986 is a reply to message #564483] Wed, 29 August 2012 16:17 Go to previous messageGo to next message
Littlefoot
Messages: 19537
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I never did that; however, see what's being said here. If you ever make it work, post it back here. People might benefit from your walkthrough.
Re: How to load data in oracle from Microsoft Access Database (.mdb) file. [message #564987 is a reply to message #564986] Wed, 29 August 2012 17:29 Go to previous message
BlackSwan
Messages: 22726
Registered: January 2009
Senior Member
>If anybody knows the way, please suggest me.
PERL can SELECT from MDB database & INSERT into Oracle from small custom routine.
Previous Topic: datapump Export taking long time(HUNG)
Next Topic: SQL*LOADER (2 Merged)
Goto Forum:
  


Current Time: Tue Sep 02 09:17:45 CDT 2014

Total time taken to generate the page: 0.09945 seconds