Run a query on multiple mdb files

Question

Hi Experts,

I am a newbie to Access. I have about 300 mdb files all with the same name, same tables under different subfolders. for example:

H:\Southern\folder1\database.mdb
H:\Southern\folder2\database.mdb
H:\Southern\folder3\database.mdb
.
.
.
.
.
.
H:\Southern\folder300\database.mdb

I want to programatically acheive the following:

1) Search for each of the mdb files in the folders
2) Open the database, Run a query (extract a few columns by joining them)
3) export the result set to an excel sheet
4) perform this for all the 300 files.

Sample codes and pointers to acheive this will be greatly appreciated.'

thanks.