DATA SYNCHRONIZATION FROM ORACLE TO MSACCESS

[nagaraj]

Hi,

IS there any way to synchronize the oracle data to MS ACCESS.

I have an oracle database , every day i need to update my all data to my MS ACCESS database.

Any suggestions appriciatable.!!

[TimHall]

You can use ODBC to create link tables in access that point to your Oracle database. Then write some code in access to refresh the data in your access tables.

Alternatively you can use Generic connectivity to read/write to your access database from Oracle directly:

http://www.oracle-base.com/Articles/...ectivity9i.asp

[Edited by TimHall on 01-09-2002 at 03:32 AM]