update oracle table via access/excel

[axelo]

Hey,
is there a way to gain access to an oracle table via MS Access/Excel with the right to modify the table?

Regards
Axel

 

[bookouri]

Create an ODBC data source on your windows machine (look on the Administrative Tools tab). Then go into Access or Excel and use that ODBC data source to link to, or import the Oracle table, depending on what you want to do with it.

This is assuming you have the Oracle client components installed on your workstation, or another ODBC driver that doesnt require the oracle components. The standard windows ODBC driver for oracle needs the oracle client.

its really a lot easier than you would expect to move data to and from access/excel/oracle

 

[axelo]

Hey,
thanks for the replay - sorry for the delay of my answer [can't constantly work on this topic ..]

I have been able to get access to an oracle table in excel. But changes that i make in excel are not transferred to access. Even by clicking on 'refresh data' the new entries do disappear. So i still can't write back in the oracle table. Any suggestions?


Regards
Axel Orth, Germany

 

[bookouri]

are you making sure your changes in Excel are committed? Until they are committed they wont appear in the other apps. If you have LINKED the tables instead of importing them, you are working on the live tables and any change should appear no matter what application you then use to access it.