-
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
Santosh
-
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.
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
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|