Thanks Dennis, link to Oracle in Access through ODBC is one option, actually good idea......, if I can get through the network. the Access and Oracle are on different network.
> -----Original Message----- > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 2:49 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Compare, Merge and replicate between Oracle and MS > Access > > James - Have you considered just maintaining the Oracle tables and then > attaching (or whatever the Access word is) the Oracle table in Access? > That > way you have a single table, single source, etc. Simple is good. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Friday, February 22, 2002 1:09 PM > To: Multiple recipients of list ORACLE-L > > > Hi DBAs, > > I am researching for solution for a new project. We have a few tables in > Oracle8i db, similar tables with more columns and more data in MS Access. > The data is very static. > > Our plan is to synchronize the two dbs, from then on we will always put > change(adding more columns, or insert new data) in Oracle first, then > replicate the change to MS access db in batch process. > > I am looking for solutions > 1) to compare the existing data in Oracle and MS Access > 2) to merge the data into Oracle > 3) to maintain the two db on ongoing basis. periodically check if they are > in synch, then replicate data to MS access. > > Is there any tool to do the job? any ideas for solution? One solution I > thought about is to use MS DTS to put Oracle into Access, then > compare..... > > TIA > James > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Xing, James > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xing, James INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).