Oracle and MS Access...
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Oracle and MS Access...

Hybrid View

  1. #1
    Join Date
    Jan 2000
    Location
    Ivanavo, Russia
    Posts
    6

    Question

    Hi, DBAs!!!

    Does anyone know how to import a database from MS Access into Oracle???

    Thanks.

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828

    Cool

    hi there

    the simplest way is to use oracle data migration assistant for acesses or odma

    the other way round is to use export acesses file into csv format and then load this file using sql loader

  3. #3
    Join Date
    Jan 2001
    Posts
    18
    Hi,

    If you prefer command prompt tools you can use Chyfo (www.ispirer.com/chyfo.hml).
    It converts Access data to CSV format and generates native CREATE TABLE, INDEX scripts for Oracle and control files for SQLoader.

    Best regards, Dmitry

  4. #4
    Join Date
    Jan 2001
    Posts
    18
    Hi,

    I'm sorry, the correct link is http://www.ispirer.com/chyfo.html

    Best regards, Dmitry

  5. #5
    Join Date
    Jan 2000
    Location
    Ivanavo, Russia
    Posts
    6
    Thanks hrishy & Ispirer.

    Migration Assistant doesn't work (java problem), but Chyfo is very usefull utility.

    Thanks again. Android.

  6. #6
    Join Date
    Mar 2001
    Posts
    635
    Hi Android,

    Why dont you try oracle software for migration you can use

    Oracle migration workbench

    here is the link you can download the software free and works from

    sql server 7 -> oracle

    ms access -> oracle

    It support allmost all rdbms which are there in the market you just need to downlaod plugins and install

    http://technet.oracle.com/tech/migration/workbench/

    And try this link which Jeff Hunter explained to me and it worked perfectly for me where you can manually set up migrating data from ms access to oracle 8i

    http://dbasupport.com/forums/showthr...threadid=11116

    Hope this helped to solve ur problem

    Regards



    Santosh

  7. #7
    Join Date
    Jan 2000
    Location
    Ivanavo, Russia
    Posts
    6
    Hi santoshym.

    I use Oracle Migration Assistent. But I have one problem. MS Access database created not myself. It contains tables, which have russian names. As result Oracle Migration Assistent generate abracadabra. :((

    Thanks. Android.

  8. #8
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    I know nothing about Oracle Migration Assistent, I am Russian guy and it is easy for me to write migration program by myself using Delphi or C++Builder you will be able to it for 30 min. If you familiar with C++ or Delphi you know what to do.
    I had deals with russian text and I did that program, belive me that is not difficult.
    Best wishes!
    Dmitri.

    Originally posted by android
    Hi santoshym.
    I use Oracle Migration Assistent. But I have one problem. MS Access database created not myself. It contains tables, which have russian names. As result Oracle Migration Assistent generate abracadabra. :((
    Thanks. Android.

  9. #9
    Join Date
    Jun 2001
    Posts
    132

    Thumbs up i use perl

    I use Perl DBI to extract data from Oracle and convert them into a tab/comma delimited file ( you can use whatever character you want as a delimiter). I needed to do this often and needed a fast and flexible way of extracting data from multiple joined tables and import them to MS Access/MS Excel (or whatever db/spreadsheet).
    You think I'm going to have an affair with you? --Stanley Kowalski

  10. #10
    Join Date
    Jun 2001
    Posts
    132

    Thumbs up got that backwards

    Sorry,

    I thought you meant extracting data from Oracle to MS Access. you can just use sqlldr then.
    You think I'm going to have an affair with you? --Stanley Kowalski

Posting Permissions

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



Click Here to Expand Forum to Full Width