Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    54

    Unanswered: Export to other database

    Is there a possibility to export an Oracle database to an other database ?
    As access file or XLS file or text file,
    to rebuild a simple database for testing ?
    (Oracle 8i)

    Thanks for answers,
    Pierre.
    Pierre (Pl-Arts)

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    The easiest way to make a copy of an oracle table in access (assuming you have an ODBC link to the oracle server) is to go to the tables tab, click on new, import table, select OBDC, select the ODBC link, login to the database, select the table and click import (OK). You now have a local copy of the oracle table in access.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •