Forum Stats

  • 3,872,090 Users
  • 2,266,378 Discussions
  • 7,911,047 Comments

Discussions

MS ACCESS TO ORACLE

673262
673262 Member Posts: 10
edited Dec 2, 2008 12:56PM in SQL Developer
Hello,

I have a table in MS Acess format on my C drive , I would like to convert to Oracle using Oracle Sql Developer .
Please let me know if any one has done this or know how to work on it .

thanks,Vinai

Answers

  • Hello Vinai,

    the Migration Workbench included in SQL Developer is dedicated for this task.

    You may at first want to read the documentation "Information for Microsoft Access Migrations" which you can find here:

    http://download.oracle.com/docs/cd/E12151_01/index.htm

    Please let me know whether this documentation is helpful for you.

    Best regards
    Wolfgang
  • -K-
    -K- Member Posts: 6,171
    edited Dec 2, 2008 4:10AM
    For just 1 table, I wouldn't go through the trouble of setting up a migration.
    I'd export to Excel (or CSV), then in sqldev 1.5.0 (not 1.5.1!) right-click the Tables node in the navigator, Import Data and you will be guided through the process of creating the table as you like...

    Have fun,
    K.
  • 673262
    673262 Member Posts: 10
    thanks to both of you .
    I was able to work with SQL DEVELOPER to get the data .
This discussion has been closed.