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

Recommended Answers

All 8 Replies

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.

hi debasisdas, good post. it help me too.

I am glad that i could help you guys.

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

Can You please explain what do you mean by copy the oracle database.

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.

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

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.