Union atuomation !

[amal1973]

Hello ..
I receive three databases every month. Every database has a table that is exactly the same in the other databases. What I would like to do is create my own database and to create a table that has the same structure as the other three tables and start appending data to it.
I rally would appreciate any help in automating this process using vba .
Thanks

 

[smitan]

A nice way to do this might be:

Have a fixed folder where to store the 3db.
In 'your' db have a form which (use DIR) shows the db's in that folder in a combobox.
In the cboAfterUpdate put code that links the table of the db chosen.

Make an append query that appends the data to the already existing table in your db.

Enjoy VBA.
Hans

 

[amal1973]

Thanks for your replay.. Any Code will help
Thanks