Home » Other » General » Convert oracle dmp file into ms access. (Oracle 9i)
Convert oracle dmp file into ms access. [message #392685] Wed, 18 March 2009 22:11 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member
Hi

Please let me know how to convert oracle dmp file to ms access. we are using oracle 9i.

Thanks and regards

Re: Convert oracle dmp file into ms access. [message #392686 is a reply to message #392685] Wed, 18 March 2009 22:14 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Please let me know how to convert oracle dmp file to ms access.
Import into Oracle & then make flat files to be read by Access.
This assume compatible datatypes.

[Updated on: Wed, 18 March 2009 22:15]

Report message to a moderator

Re: Convert oracle dmp file into ms access. [message #392708 is a reply to message #392685] Thu, 19 March 2009 00:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use imp show=y, redirect the output to a file, modify the content to make it ms access compatible and execute the statements in ms access.

Regards
Michel
Re: Convert oracle dmp file into ms access. [message #507506 is a reply to message #392708] Mon, 16 May 2011 06:38 Go to previous message
convertin
Messages: 14
Registered: May 2007
Junior Member
Try OraDump-to-Access, a program to convert Oracle dump files into MS Access databases, by Intelligent Converters:

convert-in.com/ord2acc.htm
Previous Topic: schema stats gather
Next Topic: i need help Oracle
Goto Forum:
  


Current Time: Thu Mar 28 07:36:37 CDT 2024