Append data from other mdb database

[steven]

I have multiple mdb with the same tables, fields etc... I wish to append a main database with other similiar ones... Any fast way to append all the data to the main database? Thanks

[barand]

Use access's file/import

[steven]

maybe i didnt explain my situation properly, sorry for that...
i know Access file/import feature... but it cannot work this way...

i have 5 users working on a application that uses access database. others need to run some reports on the database... so i have to create one big database which will pull in all the data from the 5 database... i cannot be importing those near 100 tables everyday!!! so what i have in mind is before they run the reports, they have to run a "importing" of all the database and this has to be done by php...

i want to know if there's any faster way than using select * and insert ...