Data from MS Access to Oracle

  • Thread starter Thread starter jbkirby via AccessMonster.com
  • Start date Start date
I never work with oracle. but I would do two of these things.

Try with ODBC

or, try to export your infotmation from access to TXT and then import in
Oracle.

It works with SQL


marco
 
I don't know how to do this. Can you please help me with this one? What do I
need to install/configure? I only have Access 2000 in my workstation now.
 
go to adminnistrative tools, then you'll find ODBC and the add a connection.
You'll have to choose the oracle drive and make the right configurations.
 
jbkirby via AccessMonster.com said:
I don't know how to do this. Can you please help me with this one? What do
I
need to install/configure? I only have Access 2000 in my workstation now.
Click to expand...

Well for a start you'll need some logon credentials for the Oracle database,
without those you can't connect. You'll need to use the ODBC connection
administrator to establish the connection. It's not a trivial task.
 
we have already our development environment for the Oracle database. I am
using oracle 7.3(orawin95) I think. I can connect through Powerbuilder but
with Access. I don't know how to set up a connection.
 
jbkirby via AccessMonster.com said:
we have already our development environment for the Oracle database. I am
using oracle 7.3(orawin95) I think. I can connect through Powerbuilder but
with Access. I don't know how to set up a connection.
Click to expand...

Open the MS ODBC Administrator. On my machine it's under Start, All
Programs, Oracle - Oracle 8I, Network Administration. What I do then is
click Add, then choose the MS ODBC driver for Oracle. Click Finish then
supply your Oracle credentials in the dialog box.

HTH - Keith.
www.keithwilby.com
 
Anyway, thanks keith. It seems that my Oracle installation is incomplete. I
only have two options in network administration, net8 assistant & net8
configuration assistant. Both of them doesn't open when I click them.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to connect to the Oracle server from Microsoft Access 1
How to connect to Oracle server from within microsoft access 1
Linking Access and Oracle Database 2
Capture ID of newly inserted row 3
MS Oracle ODBC failure in Access 07 3
Access doesn't see decimal point! 2
Access Security with Oracle back end 4
How to export table from outlook into ms access table? 0

Back
Top