Access 2000 & Merging Data from 2 Projects

[Larry H.]

Hi,

I have 2 databases, one is populated with 400+ records
and a second database from another Access 2000 project
that is empty.

I would like to bring these two DB together and use SOME
of the data from the populated DB to totally populate the
currently empty DB,,,,

Is this possible and if so, can someone please tell me
how to do this....

Thanks,
Larry H.

 

[John Vinson]

Hi,

I have 2 databases, one is populated with 400+ records
and a second database from another Access 2000 project
that is empty.

Two .mdb files? or two tables in a .mdb file? A "database" in Access
jargon is the .mdb (or .mde or...) container for multiple Tables,
Forms, Reports etc.

I would like to bring these two DB together and use SOME
of the data from the populated DB to totally populate the
currently empty DB,,,,

Is this possible and if so, can someone please tell me
how to do this....

If it's just two tables, create a Query based on the populated table,
with criteria to select the records you want; change it to an Append
query, specify the target table, and run it using the ! icon.

If it's two databases, use File... Get External Data... Link to link
to the database containing the data, and then do as above.

 

[Larry H.]

Thank you so much... This works just great. I had not
even considered the "append" option...

Thanks again,
Larry H.

 

[John Vinson]

Thank you so much... This works just great. I had not
even considered the "append" option...

Queries are your Friends. Get to know them; you'll find that they're
very helpful! <g>