Home » Other » General » transfer of files from access to oracle
transfer of files from access to oracle [message #103438] Wed, 24 September 2003 12:23 Go to next message
vaishakh
Messages: 1
Registered: September 2003
Junior Member
I am new to oracle. before i was using ms access.
now i want to transfer the data base files to oracle. with using oracle navigator how should i transfer the files?
Re: transfer of files from access to oracle [message #103439 is a reply to message #103438] Fri, 26 September 2003 07:28 Go to previous messageGo to next message
Paul
Messages: 164
Registered: April 1999
Senior Member
There is an Oracle migration workbench that will do it all for you (download it from http://otn.oracle.com/software/index.html). You will also have to downloads the appropriate plug in.

Best of luck
Re: transfer of files from access to oracle [message #103440 is a reply to message #103438] Fri, 26 September 2003 12:59 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
I am not too familiar with MS access, but cant you create link tables in Access and push the data into Oracle tables using ODBC? I thought it had that facility..or maybe I am not sure.

You can definitely extract the data into ascii text files and then load into matching Oracle tables using Oracle Sql*loader.

-Thiru
Previous Topic: ???... Oracle Direct Connect ...???
Next Topic: recreating service for autostart of instance on Win NT
Goto Forum:
  


Current Time: Thu Dec 01 17:18:46 CST 2022