5
Contributors
8
Replies
10
Views
9 Years
Discussion Span
Last Post by kevs1607
1

You can't convert directly. But you can upload data of access into oracle.
You can export the data of access into a .CSV file and from oralce use the SQL LOADER to load the same data to oracle table.

0

If the database is small u can just copy them,the paste it in the result grid in TOAD also.

I m not understand friend... Please explain more detail about the copied one.

0

Hi I have tried this @ critical times,

These were the steps I use to do

1.Select the few rows from access DB u want to copy to Oracle

2.Run the following query in oracle

Select * from table_name where rownum<5 for update;

3.We can see an extra line added to the result set grid at its end,click on the first column,so the whole row gets selected and paste the access records.

Hope i have shared wat i know.Thanks

0

how can i convert an access database to oracle database
please help me

you can use this software "acc2orad".
but problem with this software is that coversion is limited with only 5 rows of each table.

Another option is u need to migrate your access database into oracle with facility of oracle.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.