Error when trying to write dataframe to the Database(MS SQL Database, ver 14) table

I get this error:

dbWriteTable(con, "MyTable", MyDataFrame, append = TRUE)
Error in (function (classes, fdef, mtable) :
unable to find an inherited method for function ‘dbWriteTable’ for signature ‘"RODBC", "character", "data.frame"’

  1. ----- My connection string ----

con<- odbcDriverConnect(connection="Driver={SQL Server};server=dev?????\dev;database=????????; uid=????????; pwd=????????; trusted_connection=yes;")

  1. ----- I even copied data from the table, to write it back to the table -----

MyDataFrame <- sqlQuery(con,paste("SELECT * FROM MyTable"))

  1. ----- Writing data back to the database table -----

dbWriteTable(con, "MyTable", MyDataFrame , append = TRUE)

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.