importing data from one access database to another access database

[cc]

How do I import selected data and selected records from one access database
to another access database. The field names are not currently always the
same. I want to add people from one database into another database. Only
some of the fields from the first database will be used in the second
database.

 

[Daniel]

You might want to ask the question specifically in the Import/Export Data
forum.

I would use an append query. Look it up in the help for more info.

Daniel