Question Advice please - 3 backend databases for one front end?

[Chrisopia]

Hello everyone,

I am struggling to think of a solution.

Basically 3 branches each use their own back end and front end, but now it's time for marketing, and I need to create a front end database out of all three back ends.

The past 2 marketing exercises I've exported into Excel and manually merged them together - which takes time and doesn't account for duplicates.

Hope there's a solution!

 

[CBrighton]

If you can distil the process of identifying duplicates, then you can create an append or VBA code (depending on the complexity of the required comparison) to pull data from one table into another.

:edit:

By distil the process I mean define it exactly. If it can be written like a program rather than relying on human judgement and without requiring understanding of the data then you can likely automate the process.

 

[Chrisopia]

I see - so there is no way of keeping the data in a back end - they will still have to be appended into one table eventually?

Although plausible it makes things trickier in ensuring the linked data are also kept in sync (e.g. making sure key fields are matched in imported data tables)