Append new data to same SQL table in R

Try using DBI::dbAppendTable()

https://rdrr.io/cran/DBI/man/dbAppendTable.html