Appending master tables from another access DB

[TriDub]

Hello,

Is there a utility in Access 2007 (or separate program) to update/add records from a different database with identical tables/fields?
I have a working database from an application in Paradox that I convert to Access. I would like to convert this app DB each month and then update/add to my Access application with any changed / added records.

Any help is greatly appreciated! Seems like I am like many here - under tight deadlines.

Craig

 

[dhookom]

Do you have any primary keys or fields containing the last edit date/time?

You can generally import the most recent records and then run queries on tables based on the primary key joins.

Duane
Hook'D on Access
MS Access MVP