Dear all
I need to merge a number of databases of the same type into one database in access. can you please help me with code itself.
thanks.

Ampah

The easiest way to do this would be to firstly link the tables in one database to the other and then use append queries to move data into the local tables. This assumes that the tables have a similar structure between the two database.

If you need to know the source db then add an extra column to the destination table and place a value when appending identifying the source db.