hey guys whats up? i was wondering if ne1 knew the sql statement or just a way in general to append an already existing table to another already existing table. the tables are of the same format. ie colomn names and what not. thanks guys

INSERT INTO...
SELECT...
FROM...

More info in Help

p.s. i dont want to just use the append query in the design veiw. i want this to be a button that when clicked apends a table to another table. thanks

then build the SQL string like Paul showed and go one step further:

Dim strSQL as String

strSQL = "INSERT INTO... " & _
"SELECT... " & _
"FROM..."
CurrentDb.Execute strSQL