Hi everyone, am a newbie and need help moving data back to
oracle from access.
There is an odbc link between access 2000 and oracle 9i
using the export command in access copied a complete table
with data to excel so that a user could edit it (delete and add records), I imported the edited table to access and want
to replace the linked oracle database in its entirety with the edited access version and don't know how to go about it.
It should be noted that the Linked table is just a table with
2 index keys and no queries and thats it. I can't change the name of the linked table since it is being used in the network.
What is the best way of replacing the oracle linked table without changing users or table name.
I tried migrating with SQL developer without success, there
was an error and on top of that a new user was created.
Please help me, any input will be highly appreciated
Thanks
Massamiya
oracle from access.
There is an odbc link between access 2000 and oracle 9i
using the export command in access copied a complete table
with data to excel so that a user could edit it (delete and add records), I imported the edited table to access and want
to replace the linked oracle database in its entirety with the edited access version and don't know how to go about it.
It should be noted that the Linked table is just a table with
2 index keys and no queries and thats it. I can't change the name of the linked table since it is being used in the network.
What is the best way of replacing the oracle linked table without changing users or table name.
I tried migrating with SQL developer without success, there
was an error and on top of that a new user was created.
Please help me, any input will be highly appreciated
Thanks
Massamiya