Home » SQL & PL/SQL » Client Tools » how to import data stored in MS-Access to Oracle? (10g , toad , XP SP2)
icon5.gif  how to import data stored in MS-Access to Oracle? [message #322911] Mon, 26 May 2008 17:38 Go to next message
Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt
Senior Member

how to import data stored in MS-Access to Oracle?

I just need the data not the tables structure , because I made the same tables structure that at oracle like exactly in the access.

in the otherwise , is there anyway to put the tables with it's data and it's relationships all together from access to oracle ? ..... because when I used Access To Oracle v1.5 didn't give me the relationships but give me only the tables and it's data.
Re: how to import data stored in MS-Access to Oracle? [message #322956 is a reply to message #322911] Mon, 26 May 2008 23:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use an ODBC connection to Oracle database.

Regards
Michel
Re: how to import data stored in MS-Access to Oracle? [message #323547 is a reply to message #322911] Wed, 28 May 2008 14:45 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
"Access to Oracle V1.5"? Unsure what that is.

SQL Developer 1.5 is made for the job... http://www.oracle.com/technology/tech/migration//workbench/index_sqldev_omwb.html
Previous Topic: executer script from toad
Next Topic: how to not display substitutions in a spool file
Goto Forum:
  


Current Time: Sat Dec 03 18:23:13 CST 2016

Total time taken to generate the page: 0.07897 seconds