1

I am trying to add a new column to a table extracted from a MS Access database (*.accdb) and save it back again to MS Access using sqlSave(), but R-Studio shows FATAL ERROR and restarts. 

install.packages("RODBC")
library("RODBC")

conn <- odbcConnect("TEST01", believeNRows=FALSE)
Departments <- sqlQuery(conn, "select * from Departments")
Departments$New <- c(2,2,2,2,2,2)

sqlSave(conn, dat=Departments, 'Departments', append=FALSE, rownames=FALSE)

The program seems to encounter a problem and crushes after a few seconds.

Does anyone know how to solve this problem?

OBT
  • 59
  • 8
  • Possible duplicate of [RODBC sqlSave table creation problems](http://stackoverflow.com/questions/23913616/rodbc-sqlsave-table-creation-problems) – alexwhitworth Mar 15 '16 at 15:54
  • Other possible (probably more relevant) [duplicate:](http://stackoverflow.com/questions/35512259/) – alexwhitworth Mar 15 '16 at 15:55

0 Answers0