combining 3 tables

[revned12]

I have 3 imported tables namely Sheet_1, Sheet_2 and Sheet_3



They have all the same field names now I am looking for a solution in combining them into one table and name it tbl_ProjectList.

I need to do this thru a button cmd_UpdateProjectList, what I need to do all this staff?

And can anyone help how to figure out my VBA code for my cmd_UpdateProjectList?

Appreciated

thanks in advance,
revned12

[JoeM]

You can write records from one table to another using an Append Query. You will probably need two Append Queries.
Once you have created those, you can incorporate and run those with via VBA (with OpenQuery commands).
If you are unsure of the VBA syntax for that, an easy way is to create a Macro that opens those queries (to run them), and then use the "Convert Macros to Visual Basic" functionality to see what that looks like in VBA code.