Hi, DBAs!!!
Does anyone know how to import a database from MS Access into Oracle???
Thanks.
Printable View
Hi, DBAs!!!
Does anyone know how to import a database from MS Access into Oracle???
Thanks.
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
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
Hi,
I'm sorry, the correct link is http://www.ispirer.com/chyfo.html
Best regards, Dmitry
Thanks hrishy & Ispirer.
Migration Assistant doesn't work (java problem), but Chyfo is very usefull utility.
Thanks again. Android.
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
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.
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.
Quote:
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.
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).
Sorry,
I thought you meant extracting data from Oracle to MS Access. you can just use sqlldr then.