How can i Append to Table using table Variable name

Champs,

Yes we can use a variable for a table name in an append query

Try this code

Dim strSQL As String
strSQL = "Select * FROM " & variablename & " WHERE ID=?????"