Copy data between access databases with slightly different structures

[Partha Mandayam]

If I have 2 databases with some differences in table structure, 1 is fully
populated and the other empty, how can I copy only the matching fields data
from one to the other? Are there any utilities available for this?

 

[Partha Mandayam]

I want to be able to do it dynamically by just comparing the two databases.
The number of mismatched fields could vary. I need to be able to compare the
two structures and only copy data for matching fields.

 

[Vadim Rapp]

PM> If I have 2 databases with some differences in
PM> table structure, 1 is fully populated and the
PM> other empty, how can I copy only the matching
PM> fields data from one to the other? Are there any
PM> utilities available for this?


You have to write a code which would reflect your definition of matching
fields in tables with different structures.

Vadim