| Syncing of data between an Access and Oracle Table [message #73429] |
Mon, 26 April 2004 02:56 |
KC
Messages: 6
Registered: April 2004
|
Junior Member |
|
|
One of our customers has an Oracle 7.3.4 database which they use to store production data. However they also use an array of custom Microsoft Access databases for inputting of information.
They are keen to have a tool ? which goes to their Access Database and pullout relevent information via a Query and then import the data, update the data in the Oracle 7.3.4 database. They also want the tool to update the Access database as well from Oracle.
I was thinking of using SQL Loader but reading a reply in this forum SQl Loader can only import data not perform updates.
Is there supplied Oracle tools that can do a similar job or is the way forwad a custom application ?
Any pointers would be great.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
