DATA SYNCHRONIZATION FROM ORACLE TO MSACCESS
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DATA SYNCHRONIZATION FROM ORACLE TO MSACCESS

Hybrid View

  1. #1
    Join Date
    Jan 2002
    Posts
    1
    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.!!

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    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]
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width