VBA Coding to Append a table to another

[Preacher1954]

Good day to you all.
I need to do VBA coding where I want to open a table and append it to another. The reason is that in VBA I will be adding in the table names according to the user signed on.

In a normal append query the table names are mentioned, coded if you wish in the query. I want to override it programmatically.

I am new to the VBA coding scenario, hence the help requested to input a table and append it.

Much appreciated.

 

[dhookom]

I would still use an append query but I would build the query in code and run it.

Can you provide the SQL of your append query and suggest what needs to get changed and where the value comes from?

Duane
Hook'D on Access
MS Access MVP