Oracle and MS Access...

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.

You can use ODBC of Microsoft , and set a data source.