Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009
    Posts
    4

    Question Unanswered: Inserting Records in Oracle 8.1.7 database

    Hello,

    I have the database in MS Access 2000 format and also i have blank database in orcle 8.1.7 but the table structure of both the database is different. I want to import data from access data into oracle data. Pls give me some tool or any method of data import.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    One way would be to create CSV (comma separated values) file(s) from your MS Access database and load them into Oracle with SQL*Loader.

    Another way might be simpler (if you are inexperienced SQL*Loader user): Oracle Migration Workbench. It is now incorporated into Oracle SQL Developer GUI tool.

Posting Permissions

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