After reading through several previous responses on sqlSave issues, I am here yet again trying to find a solution.I am trying to save a df manual_txns to an existing table Transaction_History.cnxn <- odbcConnect(Home)sqlSave(channel = cnxn, manual_txns, Transaction_History, append = T, rownames = F)and I get an error:-Error in sqlSave(channel = cnxn, manual_txns, Transaction_History, append = TRUE,  : unable to append to table Transaction_HistoryThings that I have tried  read and tried relevant responses on SE to no availmake sure my data types and column names in R are aligned with the DBmake sure my dns has the DB name selected by default and does not point at the masterSimilar code works as expected for a different table if table is dropped every time and created again.Dropping this table however and recreating is not an option. The data will grow every month and is not efficient re-creating it every month.Any insights on what else I should be trying? I am using sql-server express 2016. R3.3.1
RODBC's sqlSave error
r;error handling