combine two databases

[donegal614]

HELP....Community Little League Baseball Database. I work on enterin
information about kids in the Baseball section. My assistant enter
info in the Softball section. We work from separate locations. We bot
work from the same master database that includes both baseball an
softball kids. How do i import her data into one big master databas
without losing the changes i've made? We are using Access 2000

 

[John Vinson]

HELP....Community Little League Baseball Database. I work on entering
information about kids in the Baseball section. My assistant enters
info in the Softball section. We work from separate locations. We both
work from the same master database that includes both baseball and
softball kids. How do i import her data into one big master database
without losing the changes i've made? We are using Access 2000.

The short answer is to either put both .mdb files on the same computer
(or the same network), and use File... Get External Data... Link to
link to the tables and then run Append queries and Update queries as
appropriate to migrate the data.

This might be fairly easy or it might be extremely difficult,
depending on how you have the database set up. If you have Autonumber
fields in your tables, say your Teams table or Player table, then you
and your assistant will have entered *different* date with the *same*
autonumber value; combining the tables by linking and doing an Append
query will fail in this case because you'll have duplicate values.

What is the structure of your tables? How are they related? This is
doable - just more or less of a tedious chore depending on the
structure!