Home » RDBMS Server » Server Utilities » question about access & oracle
icon12.gif  question about access & oracle [message #339975] Sun, 10 August 2008 11:02 Go to next message
Messages: 17
Registered: July 2008
Junior Member
dear all :
how can i transfer my access database to oracle
in other worlds
i want to transfer the tables and its data to tables in oracle without use create table and insert into .

Re: question about access & oracle [message #339979 is a reply to message #339975] Sun, 10 August 2008 12:12 Go to previous messageGo to next message
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

you can use Toad.

Steps :
Go to Database --> Create --> Table.
Specify table name
Click on the button, Load Cols From File.
Select MS Access DB File.
Select File.
Select table.
Click Ok.

To load data from Access to Oracle.
Open Toad.
Click on Database --> Import --> Import Table Data.

Note: I'm using Toad 9.0

Hope it'll help.

Saadat Ahmad
Re: question about access & oracle [message #339987 is a reply to message #339975] Sun, 10 August 2008 14:58 Go to previous message
Messages: 20848
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You might take a look at Oracle's Heterogeneous Services. Or, the most straightforward way, create a CSV file in MS Access and load it into an Oracle table using SQL*Loader (or via external tables feature (offered from 10g onwards)).

P.S. Why did you ask this question in the Forms forum? I'll move it to Server Utilities; if you feel that it should be somewhere else, please, report it to a moderator and - if you provide a valid explanation - it will be moved again.

[Updated on: Sun, 10 August 2008 15:02]

Report message to a moderator

Previous Topic: IMP
Next Topic: SQL Loader how to load header line as field
Goto Forum:

Current Time: Fri Oct 21 09:59:53 CDT 2016

Total time taken to generate the page: 0.08024 seconds