J
jbkirby via AccessMonster.com
How do you transfer data from MS Access to Oracle database?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Keith Wilby
jbkirby via AccessMonster.com said:How do you transfer data from MS Access to Oracle database?
Use an ODBC coonection and an action query.
Keith.
M
Marco
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
Try with ODBC
or, try to export your infotmation from access to TXT and then import in
Oracle.
It works with SQL
marco
J
jbkirby via AccessMonster.com
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.
need to install/configure? I only have Access 2000 in my workstation now.
M
Marco
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.
You'll have to choose the oracle drive and make the right configurations.
K
Keith Wilby
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.
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.
J
jbkirby via AccessMonster.com
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.
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.
K
Keith Wilby
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.
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
J
jbkirby via AccessMonster.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.
only have two options in network administration, net8 assistant & net8
configuration assistant. Both of them doesn't open when I click them.