How can I append a table to another table 3

[ivs7720]

Hi,

New to VBA in Access. How can I append a table to another using VBA coding?

Thank you in advance!

 

[PHV]

Provided the 2 tables have same layout:
DoCmd.RunSQL "INSERT INTO Table1 SELECT * FROM Table2"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[rubbernilly]

And, if they don't have the same layout, just remake a query to put the data of table2 into the layout of table1, and then just replace "table2" from PHV's post with that query name...

...or replace everything from "SELECT..." forward with the SQL of the query that re-formats table2 into the proper layout.

HTH

 

[ivs7720]

Another How can I break for line continuation to the next line?

 

[TheDude53]

strSQL = "yardy yardy yar " & _
"dy yardy yar"

 

[ivs7720]

Thank you all!!! It works!