Copy data between access databases with slightly different structures

  • Thread starter Thread starter Partha Mandayam
  • Start date Start date
P

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?
 
See if this is what you want. Open one database and create a link to
the table in the other database. Then create an append query. You can
choose the fields you want to append, leaving the other fields alone and/or
use criteria to chose what records you want to append.
 
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.
 
Do you mean matching field definitions or matching data in the field?

BTW I notice you have a large number of cross post newsgroups. I have
replied to all because I am not sure what ng you are reading. It is
generally not a good idea to include so many. Some appear to be off the
target from their name. I am on microsoft.public.access.
 
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
 
Back
Top