VBA for make new table and append 2 querys

[dani9]

Hi,

can anyone write me a complete code for making a new table, or better, to clear the contents from table "Append All Union" and append two tables named "Union 2/9 Append" and "Union 10/12 Append"?

Would be very grateful, because I am new to his. I could make it in Excel VBA but this is somehow different. Andone more question - do i put the code into a Module or a Class Module??

Thanks in advance!

 

[MStef]

For clear the contents from "Append All Union" table, try to use a "DELETE query",
for append try to use an "APPEND query", (or "MAKE TABLE query").

 

[dani9]

Thank you,

and is it the same as in the Excel with Dim and end sub?

 

[MStef]

I don't know, I don't deal with Excel.