Home » Other » General » Import Data from Access to Oracle
Import Data from Access to Oracle [message #101872] Tue, 06 November 2001 23:06 Go to next message
Meghna
Messages: 6
Registered: November 2001
Junior Member
Hi ,
I need to import data from MS-Access to Oracle.
Can Some one please guide me .
I tried using , the Export option of MS-Access , that can Export data to ODBC databases ,
but it says ODBC faied , the code is 3146.
thanks
meghna

----------------------------------------------------------------------
Re: Import Data from Access to Oracle [message #101875 is a reply to message #101872] Thu, 08 November 2001 06:33 Go to previous messageGo to next message
Hassan Ayub
Messages: 17
Registered: November 2001
Junior Member
First of please mention whcih particular version of Access and Oracle are you using. You can use the Oracle Migration Assisstant (Oracle 8) to migrate your Access Database to Oracle Database. The whole procedure is pretty easy and simple. The wizard guides you step by step and the whole data is converted to Oracle format quite easily.
If you still have doubts, feel free to contact me.

bye

Hassan Ayub

----------------------------------------------------------------------
Re: Import Data from Access to Oracle [message #101889 is a reply to message #101875] Sun, 11 November 2001 19:16 Go to previous messageGo to next message
Meghna
Messages: 6
Registered: November 2001
Junior Member
Hi Hassan,
I am Using Access 2000 and Oracle 8i.
I Tried the Migration Assistant but for 8i it exports data from previous versions of orcale.
Please if you can give me any lead, i am waiting .
Thanks
meghna

----------------------------------------------------------------------
Re: Import Data from Access to Oracle [message #101892 is a reply to message #101875] Mon, 12 November 2001 04:54 Go to previous messageGo to next message
Hassan Ayub
Messages: 17
Registered: November 2001
Junior Member
Hi there,
I would say you will have to use Oracle 8 for the migration assisstant. I have used the assisstant which is unfortunately not available in Oracle 8i but comes with Oracle 8. The Access files (having .mdb extension) can be easily converted to Oracle database quite easily but you wil have to use Oracle 8 and once you have transferred the data in to Oracle 8, then it can be easily read in Oracle 8i ( I have done that). As far as Access version is concerned ( for safer side) save your Access database in Access 97 format and then use the migration assisstant of Oracle 8.

I hope this answers your question but if you still have any problems feel free to contact me.

Bye

Hassan

----------------------------------------------------------------------
Re: Import Data from Access to Oracle [message #101894 is a reply to message #101875] Mon, 12 November 2001 20:18 Go to previous messageGo to next message
Hassan Ayub
Messages: 17
Registered: November 2001
Junior Member
Hi there,
If you dont have access to Oracle 8 for migrating your data, let me know how big is your Access file, probably I can help you here by migrating your Access .mdb file to Oracle and then emailing you ( if thats ok with you)...

Do let me know

bye

Hassan

----------------------------------------------------------------------
Re: Import Data from Access to Oracle [message #101912 is a reply to message #101875] Mon, 19 November 2001 16:40 Go to previous messageGo to next message
bechir
Messages: 23
Registered: November 2001
Junior Member
just curious, did what Hassen proposed worked?

thanks

----------------------------------------------------------------------
Import Data from sql 2000 to Oracle [message #101997 is a reply to message #101872] Mon, 07 January 2002 01:46 Go to previous messageGo to next message
Thiagu
Messages: 1
Registered: January 2002
Junior Member
Can I find any articles how to migrate
from MS SQL 2000 to ORACLE 8i ...?
Import Problem [message #102086 is a reply to message #101872] Wed, 06 February 2002 21:41 Go to previous messageGo to next message
Masood Akhtar
Messages: 1
Registered: February 2002
Junior Member
Hi Hassan Ayyub
I want to import data from MS Access 2000 to Oracle 8 via (Pl/sql).Please guide me.

looking forward for a positive and comprehensive response from your end
thank you
Re: Import Data from Access to Oracle [message #102088 is a reply to message #101872] Fri, 08 February 2002 05:56 Go to previous messageGo to next message
David Reddy
Messages: 1
Registered: February 2002
Junior Member
Hello Hassan:

I have an Access database on Access97 and need to migrate the database into Oracle 8.1.6 database. I need help.

Thank You

David Reddy
Re: Import Data from Access to Oracle [message #102315 is a reply to message #101872] Thu, 25 April 2002 11:09 Go to previous messageGo to next message
Tue Nguyen
Messages: 1
Registered: April 2002
Junior Member
It DOES NOT work.
Because this is a migration tool to move Oracle 7 to Oracle 8.
I can not find the way to move db from MS access to Oracle ?

Are you sure ?
Re: Import Data from Access to Oracle [message #102414 is a reply to message #101872] Fri, 24 May 2002 00:20 Go to previous messageGo to next message
Arindam
Messages: 8
Registered: May 2002
Junior Member
hi meghna,

did u solve the problem to export a database from access 2000 to oracle 8i....

if so, pls tell me how u did it....

mail : ari_gupta@setizens.com

Arindam.
Re: Import Data from Access to Oracle [message #102444 is a reply to message #101892] Fri, 07 June 2002 10:25 Go to previous messageGo to next message
Wilmar GutiƩrrez
Messages: 1
Registered: June 2002
Junior Member
Hi there,

I happen to be in the same point, but with Oracle 9i Developer Suite. I“ve been trying to import an Access 97 Database into Oracle 9i but can“t find the way. Should I understand that Oracle 8 Access Importation Wizard does not come with Oracle 9i? In that case, is importing the DB into Oracle 8 and then importing it into Oracle 9i the only way to do it? Isn“t there an easier way for a beginner? Thanks a lot for your help.
Re: Import Data from Access to Oracle [message #102507 is a reply to message #101872] Mon, 01 July 2002 10:56 Go to previous messageGo to next message
Brian Lawes
Messages: 1
Registered: July 2002
Junior Member
I just ran across this link on oracles website. I'm getting ready to give it a try myself. The Migration Workbench is 131MB and the plug-ins (one for each database you want to migrate from) are about 15MB each.
Good luck.

Re: Import Data from Access to Oracle [message #102515 is a reply to message #101872] Fri, 05 July 2002 22:03 Go to previous messageGo to next message
Sam
Messages: 255
Registered: April 2000
Senior Member
Thanks a million for yor quick reply.Fact is I`m a beginner in Oracle.
Presently doing an internship with a firm migrating from Access application
to Oracle enviroment. And I`m supposed to do this as a project. You can
imagine my fears if this fails. Is there anyway I can get in touch with
Grant per phone. Live in Berlin and will call regardless of where you are.
Thanks in advance.
Sam
PS:Grant can you please send me that message again. I sort of lost it.
Re: Import Data from Access to Oracle [message #102774 is a reply to message #101872] Sun, 29 September 2002 21:27 Go to previous messageGo to next message
Vaibhav
Messages: 13
Registered: April 2001
Junior Member
hii,
if ur using oracle 8i personal edition ,
then use the oracle navigator.
here follows the steps.
1)first of all export ur acess table to text format(comma seperated type)
2)then convert it to csv(comma seperated value)file just by ren facility in the command prompt.
3)now go to oracle navigator and select import from file option,and select the csv file followed by a single click on upload and ur job is over.
note:- if still u face amy problem ..then better u drop the original contraints from athe access table .
Re: Import Data from Access to Oracle [message #102881 is a reply to message #101875] Wed, 20 November 2002 11:47 Go to previous messageGo to next message
Frank Han
Messages: 2
Registered: November 2002
Junior Member
I have about 100 tables in MS Access2000 database and want to import them to Oracle 8i.
1. How to simple create the 100 tables in Oracle?
2. How to import the data from Access 2000 to Oracle 8i.
Please help
fhan100@yahoo.com
Re: Import Data from Access to Oracle [message #102963 is a reply to message #101872] Fri, 27 December 2002 10:09 Go to previous messageGo to next message
jaber
Messages: 2
Registered: December 2002
Junior Member
Check this Page

http://www.deakin.edu.au/webteam/documentation/access_to_oracle.html
Re: Import Data from Access to Oracle [message #103411 is a reply to message #101875] Wed, 27 August 2003 08:26 Go to previous messageGo to next message
Pierre Soum
Messages: 1
Registered: August 2003
Junior Member
Just use the Oracle Migration Workbench (free download from the oracle website).
icon6.gif  Re: Import Data from Access to Oracle [message #323128 is a reply to message #101872] Tue, 27 May 2008 06:58 Go to previous messageGo to next message
mukarum
Messages: 2
Registered: May 2008
Junior Member
Hi,

I have tried this tool Data Loader website: http://www.dbload.com
Works great for transferring individual tables and regular migrations.

Mukarram
Re: Import Data from Access to Oracle [message #323294 is a reply to message #323128] Wed, 28 May 2008 01:54 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
As someone else has 'raised this thread from the dead' I will add my 2 cents worth. To import an application from MS Access to Oracle DB, you really should use the Wizard available with 10g XE.

David
Previous Topic: History of the "Dual" Table
Next Topic: Oracle Critical Patch Update Synchronization
Goto Forum:
  


Current Time: Fri Mar 29 09:08:17 CDT 2024