Access 2000 & Merging Data from 2 Projects

  • Thread starter Thread starter Larry H.
  • Start date Start date
L

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.
 
Hi,

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

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....
Click to expand...

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.
 
Thank you so much... This works just great. I had not
even considered the "append" option...

Thanks again,
Larry H.
 
Thank you so much... This works just great. I had not
even considered the "append" option...
Click to expand...

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