Hi there,
I need your help.Please...
Here is my problem....
There are more than 50 access databases on my Network each has 4 tables.I have to find out all the databases and fetch all the data individually from each database and each tables, and populate a master database (in individual table).
For example....
here is the network directory structure ....
\\temp\week\set1\<directory1>\a.mdb
\\temp\week\set1\<directory2>\a.mdb
\\temp\week\set1\<directory3>\a.mdb
\\temp\week\set1\<directory4>\a.mdb
.....................................
.....................................
and so on.

What I did.... I found all the paths of the databases and stored the path into a temporary table called as Temp (c:\mydb.mdb)in other database.
Now I have to read each database table and write it into Mydb.mdb

Please hint me how can I do that.

a.mdb has 4 tables and My.mdb also have the same tables

Please please please Help me