Home » SQL & PL/SQL » SQL & PL/SQL » Accessing data from MS Access into Oracle using Oracle procedure (Oracle 10G, MS Access 2003)
Accessing data from MS Access into Oracle using Oracle procedure [message #603014] Wed, 11 December 2013 00:17 Go to next message
athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan
Senior Member
Hi Experts,

hopefully you all doing well.

i have an access database and an oracle database. i want to write a procedure that fetches data from access table and insert data into oracle table. i want to make it a back end job so that i can schedule it to run automatically after specified time interval.

Please suggest any other solution if my requirement is invalid.

Thanks in anticipation.

Regards
Athar
Re: Accessing data from MS Access into Oracle using Oracle procedure [message #603016 is a reply to message #603014] Wed, 11 December 2013 00:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What is the question?

Re: Accessing data from MS Access into Oracle using Oracle procedure [message #603018 is a reply to message #603016] Wed, 11 December 2013 00:35 Go to previous messageGo to next message
athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan
Senior Member
question is . how can i access ms access table from oracle environment?
Re: Accessing data from MS Access into Oracle using Oracle procedure [message #603020 is a reply to message #603018] Wed, 11 December 2013 00:43 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Have a look at this Maaher's walkthrough.
Re: Accessing data from MS Access into Oracle using Oracle procedure [message #603021 is a reply to message #603018] Wed, 11 December 2013 00:44 Go to previous message
martijn
Messages: 286
Registered: December 2006
Location: Netherlands
Senior Member
I think you have to read up on ODBC connections.
Can't be of any more help, it has been a few years since the last time I set up a ODBC connection.
Previous Topic: object type
Next Topic: ora-20000: unable to analyze table
Goto Forum:
  


Current Time: Thu Mar 28 04:09:52 CDT 2024