First, the fields must have identical names in both databases. Then with your 'new' database open go to 'File' 'Import Records' 'File' and select the file you want to import from. Select 'Matching Names' from 'Arrange by:'. Select 'Add new records' in Import Action. You can click on the right arrows by 'Field Names' to see the number of records which will be imported and the actual records. Then click on 'Import' and follow the prompts.
"First, the fields must have identical names in both databases. "
Not really. You can drag fields up and down in the import mapping dialog to match them up for import regardless of their field names. Using identical names is a good idea, particularly if you plan to script the import. With identical field names, you can use the matching names option to make sure the right fields are aligned to each other for import with one mouse click and adding any more fields to your source table won't require updating your script to keep the fields properly aligned.
For more on the dangers of importing records when you don't/can't use matching names, see here: Data loss bug : Spontaneous and erroneous import matching of new fields in specified imports !
U R right. I have a couple files where I import selected fields using a script and like you said it is much better if the names match. I just forgot about the dragging fields to import.
Thanks, I will give this a try tomorrow :)