Home » RDBMS Server » Server Utilities » Data Replication between MS Access and Oracle 8
Data Replication between MS Access and Oracle 8 [message #162137] Wed, 08 March 2006 23:07 Go to next message
cemehboob
Messages: 9
Registered: October 2005
Location: Rawalpindi
Junior Member
Hi, Experts


Please help me, I want to Replicate MS Access Data to Oracle8 Database automatically..

Regards.

Report message to a moderator

Re: Data Replication between MS Access and Oracle 8 [message #162453 is a reply to message #162137] Fri, 10 March 2006 05:15 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
1. Create a HSODBC connection to your Access database.
2. Create a database link using this HSODBC connection.
3. Create a view pointing to the Access table you want to replicate.

Now you have a view in Oracle that reads the data in Access. It will be up to date.

MHE

Report message to a moderator

Previous Topic: SQL*LOAD - master detail record
Next Topic: Information on Export - Import
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 26 08:17:46 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.