how to transfer MS-access database to oracle

oracle India
  • 14 years ago
        Dear all,
    I m  new to oracle .I want to know how to tranfer Ms-access database to oracle PLz provide me name of the software or any code .

    Mukesh srivastava

  • 14 years ago


    Did you mean export.

  • 14 years ago
    i m want to transfer my Access to oracle Table.

  • 14 years ago



    MS Access has a utility for export data. First you have to create an ODBC connection to the database. In your Access file select the table you want to export and then go to the menu bar “File/Export…”. Then is going to appear a save dialog, in the “Save as type:” option choose “ODBC Databases” and then choose the ODBC connection you just have created. You have to set some options for export the data.


    Play with that, I think is going to help. Good luck.

Post a reply

Enter your message below

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“We should forget about small efficiencies, say about 97% of the time: premature optimization is the root of all evil.” - Donald Knuth