Merge identical tables from different databases into one master database

[Ajit Singh]

Hello

I have database for each location. Every location will update some information in the databases and send it back to me. In those location based databases, information will be stored in one table called "consolidate_input". I will store these databases in one specific directory and then I want to accommodate the data of "consolidate_input" into one master database having the same identical table in the database. Please help me with VBA to do this operation. Am in utter need of it.......please help asap.

Ajit

 

[namliam]

Make a blank database
Make linked tables to each database/table
Make a consolidated table the blank database
Create an append query per table to add your data to your consolidated table
Run the queries, Currentdb.Execute "yourQueryName", in VBA

That would be the easiest way...