Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   From access to oracle (https://www.askmehelpdesk.com/showthread.php?t=8510)

  • Mar 23, 2005, 12:23 AM
    jonmich
    From access to oracle
    Hello

    Can anyone help me, I have to convert an access database to an oracle database.
    Is there someone who can help me?
  • Mar 23, 2005, 05:55 AM
    LTheobald
    Try the Oracle Migration Workbench (free download):

    http://www.oracle.com/technology//te...nch/index.html
  • Mar 23, 2005, 06:41 AM
    ScottGem
    The tool LT linked to looks good. However, since Access and Oracle are very different tools, it might be better to design the database in Oracle taking advantage of Oracle's strengths. Then Append the data to the Oracle tables. You can do this by connecting to the Oracle database from within Access using ODBC. Then run append queries, adding the data to the Oracle tables as appropriate.
  • Mar 23, 2005, 06:58 AM
    jonmich
    I don't understand
    Could yo give me a litle bit more explanation Scott?
    I don't quite understand what you mean
  • Mar 23, 2005, 04:46 PM
    ScottGem
    What didn't you understand. Not sure how I can restate it.
  • Mar 23, 2005, 11:48 PM
    jonmich
    How I have to append the data to the oracle database?
    Is this just by export in the menu?
  • Mar 24, 2005, 06:32 AM
    ScottGem
    No, you have to create an Append query. Very likely, the structure in Oracle will be different then the structure in Access. Not vastly different, but possible different enough so that you can't just copy table to table.

    Look up Append queries in Access Help. It will explain how to create them.

  • All times are GMT -7. The time now is 05:29 PM.