strSQL = "SELECT * INTO TMP_PaytableFiltered FROM Paytable"

cn.Execute strSQL

I am executing this SQL statement in Visual Basic (ADO)

but i get an error that says tha the table already exists.

does someone know how can avoid this and just overwrite the table.