| Import Data from Access to Oracle [message #101872] |
Tue, 06 November 2001 23:06  |
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  |
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 |
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 |
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 |
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
----------------------------------------------------------------------
|
|
|
|
|
|
|
|
| Import Problem [message #102086 is a reply to message #101872] |
Wed, 06 February 2002 21:41 |
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 #102444 is a reply to message #101892] |
Fri, 07 June 2002 10:25 |
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 |
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 |
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 |
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 #323294 is a reply to message #323128] |
Wed, 28 May 2008 01:54 |
 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
