how to transfer MS-access database to oracle

oracle India
  • 13 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




  • 13 years ago

    Hi,

    Did you mean export.

  • 13 years ago
    Yes!
    i m want to transfer my Access to oracle Table.
    Thanks





  • 13 years ago

    Hi,

     

    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).

Contribute

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.

“Any fool can write code that a computer can understand. Good programmers write code that humans can understand.” - Martin Fowler