Home » RDBMS Server » Server Utilities » Import MS-Access tables in Oracle 9i (oracle 9i)
Import MS-Access tables in Oracle 9i [message #359996] Wed, 19 November 2008 02:58 Go to next message
roome
Messages: 8
Registered: November 2008
Location: Muzaffarabad Kashmir
Junior Member

I wanna import access tables in oracle 9i. I already have this data in oracle 9i. Access tables contain additional information about this data. I wanna import these access table in Oracle 9i in such a way that it doesnt effect existing data, just add addional information to the database.
Re: Import MS-Access tables in Oracle 9i [message #359999 is a reply to message #359996] Wed, 19 November 2008 03:08 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I didn't try it, but you might check what Oracle Migration Workbench offers; as far as MS Access is concerned, it is integrated into Oracle's free SQL Developer GUI tool; download it from Oracle Technology Network.

Or, you can always do it "manually" - export MS Access data into a CSV file and import it into Oracle database using SQL*Loader or external tables feature.
Previous Topic: Copy DB from Primary.
Next Topic: Problem while Importing...
Goto Forum:
  


Current Time: Tue Dec 24 11:25:55 CST 2024