Importing Tables by Linking to Data Source

[oblivion86]

Hi guys,

I have 2 identical database in terms of structure but it differs in data.


Basically I would like to import data from subDatabase to mainDatabase and ensuring that there are no duplicate records.

I have used the "link to datasource method" through importing the tables to have the "updating" function.

However, this method also means that the records in mainDatabase are also imported over to subDatabase which I do not want.

Is there a method to ensure that the records are shared/update one way only? (i.e. import from subDatabase to mainDatabase and not main to sub?)

 

[oblivion86]

Hi basically what I need is to import new records and update existing records that were updated in database A to database B without replacing them in database B.

Thanks