append query

[Guest]

I want to transfer data from one access database to another access database.
The records are people. I want to copy all of the records over to the new
database, however, I only want to copy data from some of the fields. I
believe I need do an append query, but I can't figure out how to identify the
tables I want to use from the two different databases. I can figure out how
to identify one (the open database), but don't know how to select the source
database table.

 

[Joan Wild]

The simplest way would be to use File, Get External Data, Link Tables...
Navigate to your source mdb and then choose just the table you want.

Then create your append query to append from the 'linked' table to your
table in the new mdb.